PDA

View Full Version : Exporting / Importing Databases


HeadAche
11-22-2006, 10:02 AM
Since MySQL Front has gone to shit, I was wondering what people use to export databases as sql files ?? Its been a major pain since MySql front took the big dirt sleep which made light work of importing and exporting in various formarts...

davidj
11-22-2006, 10:10 AM
i use http://www.sqlmanager.net/products/mysql/manager

the lite version allows for SQL export of databases and data which is great for backing up and fed up with mysqldump

the full version has a bit more like exporting table data to about 20 different formats like excel and csv

HeadAche
11-22-2006, 10:41 AM
Whats the procedure mate. I cant see any import or export options... Does seem like a complete program, loads of features, but hard to get my simple head round...

davidj
11-22-2006, 10:42 AM
is there not an Extract database option from the tools menu

HeadAche
11-22-2006, 12:01 PM
Worked fine that for exporting... For importing I ran the SQL file I exported, Tools > SQL Script ... worked for me.

davidj
11-22-2006, 12:03 PM
ys forgot to mention that there is a full SQL script editor