The Little Guy Posted September 22, 2009 Share Posted September 22, 2009 I have MySQL Administrator on my computer, connecting to a database on my computer. I would like to copy a table from my localhost mysql to my remote mysql, anyone know how? Quote Link to comment Share on other sites More sharing options...
Garethp Posted September 22, 2009 Share Posted September 22, 2009 Go to the table, then look at the top, there should be an export tab. Use that to get an sql file, then use import on your remote phpmyadmin Quote Link to comment Share on other sites More sharing options...
Philip Posted September 23, 2009 Share Posted September 23, 2009 If you're using MySQL administrator for both local & server, the best way to do it (that I've found) Create a new project in "Backups", select the schema & tables. That'll create an export, then login with the server credentials and go to "Restore" and find the saved file. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.