Page 1 of 1

Generating a .SQL script that will create a MySQL database

Posted: Tue Feb 13, 2007 2:31 am
by impulse()
I have a database at the moment on a test server and I want phpMyAdmin to create a .SQL script that I can run on another server and will create all the tables & settings for the tables. Is this possible through phpMyAdmin or is it a CLI thing?

Regards,

Posted: Tue Feb 13, 2007 3:25 am
by Mordred
Select database -> Export
Check "Structure" and "Data", and optionally "SQL compatibility mode" if the other server is a different version.

mysqldump/mysql for command line variants if you insist doing so, although phpMyAdmin works perfectly.