I have been developing a PHP application on Win 2000 Server and the Windows compiled Version of MySQL 4.x. I now am having to port this application over to a UNIX (Solaris 8) box. I have installed the Solaris version of MySQL 4.0 onto it and can query the test database just fine. I then copied my data directory over and I cannot read the tables. Is there a procedure to export the Windows version of my database out and import it into the UNIX version of MySQL? I just don't want to have to recreate my database. Ya know? Thanks for any help!!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Porting Database from MySQL Win to MySQL UNIX???
- Thread starter dougdrury
- Start date
you can't copy yur "data" directory. that's not how.
You need to do "dump" of your tables in your Mysql db.
has instruction on how to do a dump. Basically, it takes all the values in your DB(s) and puts them into .sql file (or .txt since you can basically read it from any text editor ) and then you import that file to your db on another server.
You need to do "dump" of your tables in your Mysql db.
has instruction on how to do a dump. Basically, it takes all the values in your DB(s) and puts them into .sql file (or .txt since you can basically read it from any text editor ) and then you import that file to your db on another server.
- Thread starter
- #3
- Status