A MySQL database is not a file that can be uploaded. You'll need to use a MySQL admin tool to transfer your local MySQL database data over to your Server MySQL database. There are a number of ways to do this... You can use your local MySQL admin to create a backup SQL file of your database then run this on the admin for your server database to "restore" your data to you server database, thus creating the tables fields and data in that database.
No, here's a tip that, if you are going to be dealing with MySQL databases, will save you tons of time and generally make your like easier.
Get Navicat MySQL. This is by far my favorite MySQL admin tool. Yo can use it to administer all your local and remote databases, and the paid version (which will be a very well spent hundred bucks) allows you to connect to your local MySQL database and to your remote database, then "Drag and Drop" you local database over to the one on your server. This one function alone pays for the cost of the app time and again.
To answerer what you may be thinking - No I have no stake in the Navicat whatsoever - I know there are many free admin tools and have tried a great many of them. None I've tried so far come close to the ease and functionality of Navicat.
Hope you find this helpful.
--
Lawrence Carmer - *Adobe Community Professional*
http://www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in PHP and ColdFusion
Stay updated - http://blog.cartweaver.com
3
Replies
AdChoices