Page 1 of 1

Developing on windows and migrating mysql to Linux Server??

Posted: Tue Feb 25, 2003 5:07 am
by williery10
Hi there,
I am evaluating php and mysql and they look great but am unsure of the process of development. I would like to develop my site in php on my windows desktop. I was then going to pay a hosting company to put it on a Linux Server but am unsure about process of entering the data in to the mysql on my Windows Desktop and then getting it to the linux sever in the hosting company. Is there some sort of import or backup facility for the Windows db version that can be loaded into the Linux version. How is this normally done.
Any help would be great
Cheers
Williery(total novice)

Posted: Tue Feb 25, 2003 5:41 am
by twigletmac
Using something like phpMyAdmin:
http://www.phpmyadmin.net

it is relatively simple to export and import tables and their data between Windows and Linux.

Mac

Posted: Tue Feb 25, 2003 7:12 am
by neh
twigletmac wrote:Using something like phpMyAdmin:
http://www.phpmyadmin.net

it is relatively simple to export and import tables and their data between Windows and Linux.

Mac
you can get a back up of the whole db with phpMyAdmin .. full schema / data the lot as a single .sql file - you can then just load this on a new server and run it again in phpMyAdmin .. job done .. very painless :)

Posted: Thu Feb 27, 2003 5:01 am
by williery10
Thats great
thanks
williery