LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 02-08-2010, 11:38 PM   #1
sahil.jammu
Member
 
Registered: Jun 2008
Distribution: Ubuntu
Posts: 83

Rep: Reputation: 15
Some pointers required for configuration of Mysql on RHEL


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
 
Old 02-09-2010, 12:11 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,406

Rep: Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396
Here's a good place to start: http://dev.mysql.com/doc/refman/5.0/en/
 
Old 02-09-2010, 12:25 AM   #3
sahil.jammu
Member
 
Registered: Jun 2008
Distribution: Ubuntu
Posts: 83

Original Poster
Rep: Reputation: 15
Thanks Chris..!!
 
Old 02-09-2010, 05:19 AM   #4
sahil.jammu
Member
 
Registered: Jun 2008
Distribution: Ubuntu
Posts: 83

Original Poster
Rep: Reputation: 15
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...!!
 
Old 02-09-2010, 05:24 PM   #5
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,406

Rep: Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396
See the mysqldump cmd at that link for backups; restore techniques will be shown also.
 
Old 02-09-2010, 09:40 PM   #6
anomie
Senior Member
 
Registered: Nov 2004
Location: Texas
Distribution: RHEL, Scientific Linux, Debian, Fedora
Posts: 3,935
Blog Entries: 5

Rep: Reputation: Disabled
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.)
 
Old 02-11-2010, 03:53 AM   #7
sahil.jammu
Member
 
Registered: Jun 2008
Distribution: Ubuntu
Posts: 83

Original Poster
Rep: Reputation: 15
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..!!
 
Old 02-11-2010, 05:33 PM   #8
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.9, Centos 7.3
Posts: 17,406

Rep: Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396Reputation: 2396
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.
 
Old 02-12-2010, 08:39 AM   #9
pliqui
Member
 
Registered: Feb 2007
Location: Caracas, Venezuela
Distribution: Debian x64
Posts: 156

Rep: Reputation: 17
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is a reboot required after RHEL 5 kernel update? SteveJenkins Red Hat 3 12-07-2009 10:50 PM
Drivers required of RHEL 3.0 for HP proliant ML 110 G5 nirmit Linux - Newbie 7 10-13-2009 08:26 AM
How Much Hard Disk Space required to install RHEL AS 5.0 singh_chitranjan Linux - Newbie 1 06-24-2008 01:22 AM
Where would I get required RPM's to install RHEL-4 on my SATA HDD mohd anas Linux - Hardware 1 11-07-2006 05:40 AM
RHEL 3 - DNS Server Config - Help Required krishvij Linux - Newbie 3 02-27-2005 10:36 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 03:34 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration