From MySQL Windows to MySQL Linux

eyekkon

Good day everyone,

I have test server with an Apache, MySQL and PHP setup on a Windows XP box. The actual server runs Linux RedHat 9 with the same setup. Should I not be able to use the same MySQL databases and PHP pages simply by uploading them to the server?

Clearly my background has only included Windows... But I'm trying to change!!! 😃

Any help is greatly appreciated.

Cheers

eyekkon

LordShryku

You'll probably need to export the tables and import them into the Linux DB. Generally, Windows and Linux don't read each other's files without some sort of program to interpret them.

lives4him06

this can be done by:

In windows

in the command line something like:
mysqldump.exe databasname < output.txt

upload the .txt file to your linux machine

on your linux machine in the mysql executable (the one where you can manually edit each of the tables):

you may need to create the database first, i dont remember

type:

source output.txt

and all your current tables are created and rows are filled

pretty cool huh?

piersk

Hint: use phpMyAdmin

eyekkon

I thank you all for your suggestions!

How exactly would I go about it using phpMyAdmin? The Test and Production servers are different machines and both have phpmyadmin installed on them. How would I get the one on the Production Server to update the database?

Thanks again for everyone's help.

Cheers

eyekkon

pseudonym

Dont use PHPmyadmin if you have a large database.. that's a no-no. It's ok for small but once you get 100mb+, it's unreliable unless you have a nice powerful PC/server.

Instead.. do this:

1) Start Menu->run->cmd->enter (black command window).

2) Navigate to your MySQL/bin folder (eg.. C:/mysql/bin) by using the CD and CD .. commands (if you don't know those then google will explain that).

3) Type:

mysqldump --opt -uDBuser -p DBname > DBname.sql

(replacing dbuser and dbname with your own user and database name).

Hit enter and it will prompt you for the user's password. Type that, hit enter...

After a moment or two (depending on the size of your database), you will have a .sql file located in your mysql/bin folder.

Now.. copy it over to your Redhat/Fedora/*nix box, where you have access to the mysql prompt (normally it should run at the prompt depending on your configuration).

At the shell type:

mysql -uUSER -p

It will prompt you for a the password for USER (replace with whatever user you setup mysql with .. if none.. then it will be root).

Type:

create database DBname;

(replace DBname with the DBname of the one you dumped on the Windows box).

Type:

grant all privileges on DBname.* to DBuser@localhost;

(replace DBname with the DBname of the one you dumped on the Windows box and DBuser with a username of your choice).

Type:

set password for DBuser@localhost = password ('DBpass');

(replace DBpass with a password of your choice).

Type:

exit

You will leave mysql.

Then finally (yeah.. finally)..

at the shell type:

msyql -uDBuser -p DBname < DBname.sql

(replace with the values you should know by now). The sql file will then populate the db and you are up and running 🙂

Any problems, post back 🙂