1
nobita
restore database
  • 2006/1/1 22:59

  • nobita

  • Just popping in

  • Posts: 11

  • Since: 2005/12/16


I'm trying restore my database on the server (backup from localhost). I'm using bigdump but I don't find the file called "config.php" (Where I can put values of my database into).

Who can hepl me?

Thanks for your support!

2
JMorris
Re: restore database
  • 2006/1/1 23:07

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


You put the values in bigdump.php

Quote:
// USAGE:

// 1. Adjust the database configuration in this file
// 2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE"
// 3. Create the working directory (e.g. dump) on your web-server
// 4. If you want to upload the dump files directly from the web-browser give the scripts
// writing permissions on the working directory (chmod 777 on a Linux based system)
// 5. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
// 6. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
// 7. BigDump will start the next import session automatically if you enable the JavaScript
// 8. Wait for the script to finish, do not close the browser window
// 9. IMPORTANT: Remove bigdump.php and your dump files from the web-server


Hope this helps.

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.

3
nobita
Re: restore database
  • 2006/1/1 23:24

  • nobita

  • Just popping in

  • Posts: 11

  • Since: 2005/12/16


Quote:

// 1. Adjust the database configuration in this file


I'm finding the file called that I can put in value of my database, what is it name? Which folder contain it?

Thanks!

4
JMorris
Re: restore database
  • 2006/1/1 23:35

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


I don't know what you mean by

Quote:
I'm finding the file called that I can put in value of my database, what is it name? Which folder contain it?


If your hosting provider created your database, or if you use cPanel, you should have the database name, database username, and database password. The only file you should need to worry about is the database dump file you create with a tool like phpMyAdmin.

Once you get your database dump file created (read the notes in bigdump.php regarding this), do the following.

1. Open bigdump.php in a text editor and look for the following lines:

// Database configuration

$db_server   "localhost";
$db_name     "";
$db_username "";
$db_password "";


Change them to the values of your database, like so;

// Database configuration

$db_server   "localhost";
$db_name     "[color=FF0000]mydatabase[/color]";
$db_username "[color=FF0000]myusername[/color]";
$db_password "[color=FF0000]mypassword[/color]";


Just a little further down in the file you should see the following:

// Other Settings

$filename        "";     // Specify the dump filename to suppress the file selection dialog


Change that value to the name of the database dump file. For example, when you exported your database, you should have ended up with something like my_database.sql. Put the filename in the definition above, like so:

// Other Settings

$filename        "[color=FF0000]my_database.sql[/color]";     // Specify the dump filename to suppress the file selection dialog


Upload your database file and bigdump.php into the same directory on your server. Then execute the bigdump.php script by calling it from your browser, like so:

http://yourdomain.com/bigdump.php

I hope this is a little more clear.

Best Regards,

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.

5
nobita
Re: restore database
  • 2006/1/1 23:58

  • nobita

  • Just popping in

  • Posts: 11

  • Since: 2005/12/16


I did same you tell me, but....
Fatal errorCall to undefined function: xoops_gethandler() in /home/user/domains/mydomain.com/public_html/home/header.php on line 34

6
JMorris
Re: restore database
  • 2006/1/2 10:53

  • JMorris

  • XOOPS is my life!

  • Posts: 2722

  • Since: 2004/4/11


BTW, what version of XOOPS are you using?

The following thread is the only one I could find that had the same error message. Try the suggestions listed there and see if that helps in your situation.

Link: Click Here

Hope this helps,

James
Insanity can be defined as "doing the same thing over and over and expecting different results."

Stupidity is not a crime. Therefore, you are free to go.

Login

Who's Online

370 user(s) are online (266 user(s) are browsing Support Forums)


Members: 0


Guests: 370


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits