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
Can the script sql file created be used with Phpmyadmin?
Moderator: jr
-
- Posts: 8
- Joined: Tue Mar 30, 2010 8:48 pm
-
- Posts: 8
- Joined: Tue Mar 30, 2010 8:48 pm
Re: Can the script sql file created be used with Phpmyadmin?
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
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