PDA

View Full Version : [ubuntu] [SOLVED] MySQL Import / Export



CrusaderAD
November 25th, 2008, 06:01 PM
Is there an Import / Export feature in MySql Administrator? I only see backup / restore.

divinequran
November 25th, 2008, 06:26 PM
You can use mysqldump to take backup or export database.

CrusaderAD
November 25th, 2008, 06:37 PM
When I try and restore the backup up database, I get an error:

Error: Invalid character set selected for file.

I selected utf8. I think the source is MyISAM but there isn't a selection for that type.

CrusaderAD
November 25th, 2008, 06:44 PM
In reference to my last post, I selected latin1 and it restored the backup.

Thirtysixway
November 25th, 2008, 09:29 PM
PhpMyAdmin has an export/import feature.

CrusaderAD
November 26th, 2008, 02:54 PM
Thanks! Problem Solved.