Can the script sql file created be used with Phpmyadmin?

General usage of Access to MySQL

Moderator: jr

Post Reply
basementjack
Posts: 8
Joined: Tue Mar 30, 2010 8:48 pm

Can the script sql file created be used with Phpmyadmin?

Post 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
basementjack
Posts: 8
Joined: Tue Mar 30, 2010 8:48 pm

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

Post 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
Post Reply