Page 1 of 1
Import/Export Mysql
Posted: Fri Feb 05, 2010 7:13 pm
by andr3iu7z
Can someone post a guide for IMPORT/ Export for mysql?
In navicat or anyother program that are u using
Re: Import/Export Mysql
Posted: Fri Feb 05, 2010 8:21 pm
by mgbhard
In Navicat:
Export:
1º Right Button
2º Dump SQL File
Import:
1º Right Button
2º Execute Batch File
1 thing, if you are not using the latest version of navicat, then upgrade before dumping a db, cause old versions doesn't use "compete inserts", so the import will take hours.
I really recommend you to use the "MySQL GUI Tools" for backup and restore task.
Re: Import/Export Mysql
Posted: Fri Feb 05, 2010 10:43 pm
by andr3iu7z
navicat premium 8.2
i need to take each new table (account_Data, characters etc etc) and so on?
Code: Select all
[Err] 1062 - Duplicate entry 'zedone' for key 'PRIMARY'[Err] INSERT INTO `accounts` (`login`, `password`, `lastactive`, `accessLevel`, `lastIP`, `lastServer`, `email`) VALUES ('zedone', 'OvLzcDU42P+msJ1zEJQYKdGo9/0=', 1265322029937, 0, '78.183.26.38', 2, NULL);[Msg] Finished - Unsuccessfully
one of the error
Re: Import/Export Mysql
Posted: Fri Feb 05, 2010 11:04 pm
by andr3iu7z
Ok i did. Thank you very much for info. without you i wouldnt succes