Can the script sql file created be used with Phpmyadmin?

General usage of Access to MySQL

Moderator: jr

Can the script sql file created be used with Phpmyadmin?

Postby basementjack » Tue Mar 30, 2010 8:55 pm

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?

Postby basementjack » Sun May 30, 2010 1:43 am

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


Return to General

Who is online

Users browsing this forum: No registered users and 1 guest

cron