copying db with phpmyadmin
Hi, I am trying to copy my db so I can have a backup db, but when I import this in to my new db I receive the following.
I'm using phpmyadmin and have structure, data, complete inserts checked and saving it as a file. I do not understand why I get this error. could the worldclock module have some bad sql in there?
Thanks for any help.
-- Dumping data for table 'worldclock_locations'
--
INSERT INTO worldclock_locations( wid, name,
VALUES )
VALUES ( 1, 'Afghanistan',
'a:10:{s:3:"gmt";d:4.5;s:3:"dst";i:0;s:5:"s_mon";i:0;s:5:"s_nth";i:0;s:5:"s_dow";i:0;s:6:"s_time";i:0;s:5:"e_mon";i:0;s:5:"e_nth";i:0;s:5:"e_dow";i:0;s:6:"e_time";i:0;}'
) ;
MySQL said:
Documentation
#1064 - 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 'values) VALUES(1, 'Afghanistan',
'a:10:{s:3:"gmt";d:4.5;s:3:"dst";i:0;s:5:"s_mon' at line 1
[
Easier way
Just do an export. I like to save as a .gz
Then test it by doing an import into an empty database.
---------------------
"He's said to be outspoken, but nobody's actually seen anyone do it"
easier way export
Hi, thanks, but this is what I have done. I choose export, check structure, data, complete inserts and save as file. I leave the file type at sql and do not choose any compression method. and when I go in to an empty database and import it I get the error.
Try it without the worldclock
Try it without the worldclock table. This usually works for me.
---------------------
"He's said to be outspoken, but nobody's actually seen anyone do it"
Enclose table and field names with backquotes
See http://drupal.org/node/374966 :-
Select the check box labeled "Enclose table and field names with backquotes"