Import/Export Mysql

[andr3iu7z]

Can someone post a guide for IMPORT/ Export for mysql?
In navicat or anyother program that are u using

[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.

[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

[andr3iu7z]

Ok i did. Thank you very much for info. without you i wouldnt succes