Trouble importing database


#1

I’m working on getting a new test forum setup for my SMF forum install. I exported a backup of my database for my live forum and have been trying to import it into the database for my new test forum. I’m using bigdump, because the file size is around 107mb.

Bigdump looks like it runs successfully, doesn’t give any error messages, but not all of the database tables are being imported. It’s missing the last 20 tables. I checked the .sql file, and confirmed that the file itself does go all the way to the last table.

Any ideas on how I might be able to successfully import my backup database?


#2

Upload your sql file to your server via SFTP. If you haven’t created a database yet, do that first in your Dreamhost panel. Connect to your server via a shell account via PuTTY or the like. Then run the following command (change out database user name, mysql host name, database name, and path to your file on your server):

mysql -u dbuser -p -h dbhost.yoursite.com dbname < /path/to/backup.sql

Good luck!


#3

Thanks! I gave that a try, but it gave me back an error message.

ERROR 1064 (42000) at line 203695: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’`B/help-desk/new-spec’ at line 1

Here is the line in question, along with the surrounding ones:

[quote]203693: INSERT INTO smf_pretty_urls_cache (url_id, replacement) VALUES(‘B/index.php?action=emailuser;sa=email;msg=2340291', 'B/emailuser/?sa=email;msg=2340291’);
203694: INSERT INTO smf_pretty_urls_cache (url_id, replacement) VALUES(‘B/index.php?topic=5632.msg2340291', 'B/help-desk/new-species-of-demons/msg2340291/’);
[color=red]203695: INSERT INTO smf_pretty_urls_cache (url_id, replacement) VALUES(‘B/index.php?action=post;quote=2340291;topic=5632.0;last_msg=2340314', 'B/help-desk/new-species-of-demons/?action=post;quote=2340291;last_msg=2340314’);[/color]
203696: INSERT INTO smf_pretty_urls_cache (url_id, replacement) VALUES(‘B/index.php?action=reporttm;topic=5632.0;msg=2340291', 'B/help-desk/new-species-of-demons/?action=reporttm;msg=2340291’);
203697: INSERT INTO smf_pretty_urls_cache (url_id, replacement) VALUES(‘B/index.php?action=post;quote=2340301;topic=5632.0;last_msg=2340314', 'B/help-desk/new-species-of-demons/?action=post;quote=2340301;last_msg=2340314’);[/quote]

Any ideas?