Gossamer Forum
Home : Products : Gossamer Links : Discussions :

SQL dump file importing question..

Quote Reply
SQL dump file importing question..
Hi

When I tried to import the Dump file from the old server to the new one using the SQL monitor (run queries saved on file) I got:

MySQL said: Table idleb_com_-_links.ad' doesn't exist.

Query: INSERT INTO ad VALUES (5,'Mysites Services','','','Mysites','Mysites',0,1,1,0,0,0,1,1);

Any one has any idea?



Or may be an actual SQL monitor quesry with drop create function might work?
Regards
KaTaBd

Users plug In - Multi Search And Remote Search plug in - WebRing plug in - Muslims Directory
Quote Reply
Re: [katabd] SQL dump file importing question.. In reply to
How did you create the backup?

ssh> mysqldump --add-drop-tables -uUsername -pPasswod DatabaseName > file.sql

???

Looks like it didn't create the 'CREATE TABLE' statements in your backup...

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!