Is there any way I can import a mysql database or table to my sql server through phpmyadmin? I see an export button but not import.
importing SQL databases
| yooksauce wrote: |
| Is there any way I can import a mysql database or table to my sql server through phpmyadmin? I see an export button but not import. |
The export button generates a SQL script (create tables, insert rows etc) containing all your data.
To import this, you just need to execute this SQL script on the target server.
I'm sure you'll be able to find a place to execute SQL statements in phpMyAdmin.
p.s. - phpMyAdmin will accept queries directly pasted into the text box OR SQL script file OR gzipped SQL scripts.
Thanks, just figured it out. Had some trouble because the source version of sql was 3.23, so i was getting syntax errors. But exporting with mysql4.0 compatibility worked.
Related topics
 |