I would like to remove a database from one server to another..using Phpmyadmin for making backups and SSH to import database to another server. I don' t know what fileds to check usinh PHP export tool.

For example If I check extended field there are problems using SSH. What fields do I have to check to remove full database from the old server?



SQL optionshttp://datingsoftware.org/phpmyadmin/themes/original/img/b_help.png (http://datingsoftware.org/phpmyadmin/Documentation.html#faqexport)
Add custom comment into header (\n splits lines):
Enclose export in a transaction
Disable foreign key checks
Structure: .............checked
Add DROP TABLE ............checked
Add IF NOT EXISTS ...........checked
Add AUTO_INCREMENT value ..................checked
Enclose table and field names with backquotes ----------checked
Add into comments
Creation/Update/Check dates
Data: ................checked
Complete inserts
Extended inserts
Use delayed inserts
Use ignore inserts
Use hexadecimal for binary fields ...............checked
Export type: INSERT

Is that alright?

if you have SSH access, just use the mysqldump command. Its a lot easier.

You might try this:

Structure: .............checked
Add DROP TABLE ............checked
Add IF NOT EXISTS ...........unchecked
Add AUTO_INCREMENT value ..................unchecked
Enclose table and field names with backquotes ..................checked
Data: ................checked
Complete inserts ..................Checked
Extended inserts ..................Unchecked
Use delayed inserts ..................Unchecked
Use ignore inserts ..................Unchecked
Use hexadecimal for binary fields ...............checked
Export type: INSERT

This should give you a very simple SQL dump.