FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


importing SQL databases





yooksauce
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.
mOrpheuS
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. Wink

p.s. - phpMyAdmin will accept queries directly pasted into the text box OR SQL script file OR gzipped SQL scripts.
yooksauce
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
SQL Tutorial
[RESOLVED] What happened!
Phpnuke/mysql database help needed
Anybody heard of the Moved.in web host?
Hello!
PostgreSQL and Console Access
Can I create many SQL database by my self
SQL Disk usage?
Really????
Server uptime
Question about SQL
MySql to SQL
SQL Databases for another web site !
Reading from SQL databases..
This topic is locked: you cannot edit posts or make replies.    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.