Export MySQL

JamesU2005 · 10 Oct 2007 at 21:07

I need to export a MySQL database from my servers to another.

What I need though is to export the database as pure text. By this I mean text which states everything like, create table x, insert record y, etc etc.

I think this exists but just not sure what the correct method is in MyPHPAdmin.

Any ideas?

Cheers.

SiriusB · 10 Oct 2007 at 21:15

Code:

mysqldump -u root - p databasename > somefile.sql

At least I think so - that's from memory.

JamesU2005 · 11 Oct 2007 at 09:20

Thanks but I was thinking more of the Export tab in phpMyAdmin.

There seems to be a whealth of options there and don't know what to tick/untick.

uk_viper · 11 Oct 2007 at 09:41

just tick the option save as file and that should do it

JamesU2005 · 11 Oct 2007 at 09:47

I realise that I should export as MySQL.

It just all of the following Im not sure what to tick or untick:

SQL options:
Add custom comment into header (\n splits lines)
Enclose export in a transaction
Disable foreign key checks
SQL compatibility mode

Structure:
Add DROP TABLE
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Add into comments
Creation/Update/Check dates Data
Complete inserts
Extended inserts
Maximal length of created query
Use delayed inserts
Use ignore inserts
Use hexadecimal for binary fields

nikebee · 11 Oct 2007 at 09:50

You should be able to just leave everything on default and export it

JamesU2005 · 11 Oct 2007 at 10:08

Thought as much.

Found the phpmyadmin wiki which helped:

http://wiki.cihar.com/pma/FAQ_6.12

Thanks for the help all.