Developing on windows and migrating mysql to Linux Server??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
williery10
Forum Newbie
Posts: 15
Joined: Thu Feb 20, 2003 4:23 am

Developing on windows and migrating mysql to Linux Server??

Post 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)
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
neh
Forum Newbie
Posts: 16
Joined: Tue Jul 23, 2002 3:08 am

Post 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 :)
williery10
Forum Newbie
Posts: 15
Joined: Thu Feb 20, 2003 4:23 am

Post by williery10 »

Thats great
thanks
williery
Post Reply