Topshed Posted March 28, 2012 Share Posted March 28, 2012 Hi . I am using PHP ver 5.2.8 mySQL ver 5.1.30 I have backed up my database and tables to my WAMP server and I have been cleaning them up and updating some of the records My Question: How do I transfer the latest table back to my Hosting server so that it updates all the changes and the 2 tables match exactly Preferably using phpMYadmin Thanks Topshed Quote Link to comment Share on other sites More sharing options...
guru62 Posted March 28, 2012 Share Posted March 28, 2012 in phpmyadmin, select ur database and hit the export tab, make sure data is checked and save to a file. after that go to your hosting providers phpmyadmin delete that database and simply create a new empty database and import the file you made. simples. Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted March 28, 2012 Share Posted March 28, 2012 the easiest way is through the command line, this can import a file about 100 times faster than phpmyadmin. cd C:\wamp\bin\mysql\mysql5.1.xx\bin mysql -h localhost --password=xxxxxx -u username databasename < C:\my_sql_file.sql replace xxxxxx with your password, databasename with the name of your database and my_sql_file.sql with the name of your sql 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.