Page 1 of 1

Can the script sql file created be used with Phpmyadmin?

Posted: Tue Mar 30, 2010 8:55 pm
by basementjack
Hi Sorry for the noob question,

I don't have direct access to the MYSQL install.

I used Access to MySQL to create a nice .sql file that has all the create table statements as well as insert statements. VERY AWESOME!

I'm wondering if there's a way to use this in phpMyAdmin ?

Thanks,

-Jack

Re: Can the script sql file created be used with Phpmyadmin?

Posted: Sun May 30, 2010 1:43 am
by basementjack
I'll answer my own question with the hope that it'll help someone else.

Yes, it can be if it's small enough.

Use the phpMyAdmin 'Import' feature - please note that depending on the options selected in Bullzip's Access to MySql, it's likely to drop the database and recreate it.
so backup first.

If the file is too big, you can import it from the command line using redirection.

ie ./mysql -ppassword -uuserif DATABASENAME(inMySQL) < dumpfile.sql