Some pointers required for configuration of Mysql on RHEL

sahil.jammu · 02-08-2010, 11:38 PM

I am new to mysql can some one provide me the documentation or some recommended links to start the configuration of mysql server on RHEL

Also if i get the database schema, how can i replicate the same in my machine.
Any documentation for this??

Many thanks in advance.

Regards
Sahil

chrism01 · 02-09-2010, 12:11 AM

Here's a good place to start: http://dev.mysql.com/doc/refman/5.0/en/

sahil.jammu · 02-09-2010, 12:25 AM

Thanks Chris..!!

sahil.jammu · 02-09-2010, 05:19 AM

Also can you please advice on how to take database dump and restore.
I have to setup new mysql server and have to dump in all the data from already existing server...

Can you advice on steps to be followed...!!

chrism01 · 02-09-2010, 05:24 PM

See the mysqldump cmd at that link for backups; restore techniques will be shown also.

anomie · 02-09-2010, 09:40 PM

I'm normally strictly a CLI guy, but when it comes to MySQL I've found phpMyAdmin to be invaluable.

Just be aware that using it comes at a price. (You'll need to be able/willing to deploy the rest of the application stack -- namely a web server and php environment.)

sahil.jammu · 02-11-2010, 03:53 AM

Hi Thanks for your replies:-

I have a query,

The scenario is We have two machines connected over LAN, i just have SSH access to other machine (where all the database is there), i just configured the mysql server, using RHEL5... I want to have all the database replicated to my machine which exists on other machine.

What should be the simplest process, to achieve this....

i read about mysqldump as mentioned by chris...not sure how to take care of ssh part etc..!!
Can you plz provide pointers on steps needs to be followed..!!

chrism01 · 02-11-2010, 05:33 PM

Do you need

1. full on real time replication? http://dev.mysql.com/doc/refman/5.0/...iguration.html
2. regular backups & copy to backup server just in case? In this case you write a backup script to use mysqldump then scp the file across.

pliqui · 02-12-2010, 08:39 AM

For quick dump you can use the mysqldump command as chrism01 said.

There is my mysqldup script i'm using in my debian box.

Code:

mysqldump --opt -u user_name --password=your_password db_name > path_to_file/backup.`date +%Y.%m.%0e`.sql

and to restore the file is just simple

Code:

mysql --user=user_name --password=your_password db_name < name of the file.sql

Hope it helps