LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
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 01-28-2005, 03:18 AM   #1
imangm
LQ Newbie
 
Registered: Jan 2005
Posts: 2

Rep: Reputation: 0
Copying MySQL and Email Accounts


Hi,

I have a linux server. My hosting company sent an email to me and told me they have do some maintenances on my server. They seted up a new drive for me and copied my old information in /mnt directory.

I have to create all websites on this server. I'm creating them but I don't know how to copy MySQL and Email Accounts from my backup to the new drive.

Any ideas?
 
Old 01-28-2005, 03:29 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,516

Rep: Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501
For mysql you need to copy the directroy "data" or "var" (depending if you installed mysql fron binary or source) which contains you databases.
For your users there is a script named newusers (man newusers) which will help you recreate their accounts.

Good luck
 
Old 01-28-2005, 03:39 AM   #3
imangm
LQ Newbie
 
Registered: Jan 2005
Posts: 2

Original Poster
Rep: Reputation: 0
Hi,

thank you for your help.
Does MySQL work just like the past if I copy /data and /var directories to new drive? I mean If I copy these directories, do all databases and databases users and privileges restore?

Thanks
 
Old 01-28-2005, 06:13 AM   #4
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 11,516

Rep: Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501Reputation: 1501
Mind that you must copy the directory containing the databases which is named data or var according to your installation. There must be only one of those directories (I guess it is data since it's more common installing from binary). Copy it under your newlly installed mysql directory (better stop mysqld before copy) and pay attention to the permissions. The databases are owned my user/group mysql/mysql

Regards
 
  


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
Email client that support HTTP email accounts tumana Linux - Software 6 04-29-2005 09:26 PM
email accounts crazy diamond General 2 10-13-2004 09:02 AM
evolution - copying email accounts CRego3D Linux - Software 2 09-25-2004 11:42 PM
email user accounts bhughesiii Fedora 0 09-13-2004 04:55 PM
libnss-mysql (Store your UNIX user accounts in MySQL) markus1982 Linux - Security 0 01-26-2003 03:24 AM


All times are GMT -5. The time now is 02:00 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