Having Trouble Backing Up / Restoring DB - Page 2

TygerTyger · 19th January 2010, 05:20 PM

That's what I tried first, but it doesn't seem to do anything. Just printed the MySQL help and then returned me to the cursor. Nothing in MySQL's processes. No errors even with --show-warnings flagged.

The file is a single table rather than a complete database, does that make a difference? I tried load data infile as well, it did the same thing.

mark.willis · 19th January 2010, 07:19 PM

how big is the sql file? if you pm me a copy I'll take a look at it, and test it on one of my servers?

m_c · 20th January 2010, 01:52 AM

Remember you need to set the host for a United Hosting server, using the -h option (should be -h 127.0.0.1).

TygerTyger · 20th January 2010, 09:50 AM

Quote:

Originally Posted by mark.willis

the ` will be getting executed in the bash terminal ... how are you running the command?

I tried a backup without backticks and it still gave syntax errors at the same point, I guess it just doesn't work that way. Thank you for your very kind offer!

Quote:

Originally Posted by m_c

Remember you need to set the host for a United Hosting server, using the -h option (should be -h 127.0.0.1).

Thanks, I tried that but the result was the same. Nothing happened. For the prosperity of future searchers, here's what does work:

Code:

cd /var/www/html/

mysql -h 127.0.0.1 -uusername -ppassword example_com_db < example.sql

It will again return you to the command prompt without any status messages, but the import should have been successful.

mark.willis · 20th January 2010, 02:40 PM

It should work really. Are you able to display/pm a copy of the sql file and I can look further into this?

Mark

TygerTyger · 22nd January 2010, 03:40 PM

That was what support told me to use. But I came across a way to execute the backups, here it is for the benefit of searchers. This assumes you've exported the database using phpMyAdmin and uploaded the exported file to your root folder.

Code:

// Set the directory
cd /var/www/html/

// If the database is gzipped, unzip it. Otherwise, skip this step
gunzip example_db_com.sql.gz

// Connect to Mysql to save doing it every time.
mysql -h 127.0.0.1 -uusername -ppassword

// Select the database to save doing it every time
\u example_db_com

// Now you can just execute the file.
\. example_com_db.sql

UH-Tony · 22nd January 2010, 08:33 PM

Just to clarify, the method you used Tyger is the same as:

cd /var/www/html/
gunzip example_db_com.sql.gz
mysql -h 127.0.0.1 -u username -ppassword -D example_db_com < example_com_db.sql