LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 07-27-2008, 03:44 AM   #1
halvorls
Member
 
Registered: Jun 2008
Posts: 78

Rep: Reputation: 15
How can i copt the MYSQL Database to a other server (Database)


Hi!

How can i copt the MYSQL Database to a other server (Database)?

Halvor.
 
Old 07-27-2008, 08:05 PM   #2
billymayday
Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
It depends on your database type, but look into mysqlhotcopy. Otherwise you can dump the data to a text file and read it in at the other end, but the former method is simpler if supported

Quote:
mysqlhotcopy works only for backing up MyISAM and ISAM tables, and ARCHIVE tables
 
Old 07-27-2008, 08:06 PM   #3
gilead
Senior Member
 
Registered: Dec 2005
Location: Brisbane, Australia
Distribution: Slackware64 14.0
Posts: 4,123

Rep: Reputation: 151Reputation: 151
You could just tar up the directory structure and use scp to copy it over. You could also backup the database and tar/ssh the backed up data. It depends what your requirements are. The docs for backing up version 5.0 databases are here
 
Old 07-27-2008, 09:19 PM   #4
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.5, Centos 5.10
Posts: 16,280

Rep: Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032Reputation: 2032
You could use mysqldump to export the db, then just import it back in, or maybe use replication (although that's overkill for a one off).
 
  


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
Migrate MySQL database to new server babal Linux - Server 4 11-21-2007 01:31 AM
Migrate MySQL database to new server babal LinuxQuestions.org Member Intro 1 11-17-2007 04:45 AM
How can i change my Database server name from localhost to mysql? alxbob Linux - Server 1 10-19-2007 02:06 AM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 02:43 PM
Using the MySQL Database for Authentication on Apache Server ruiseixas Linux - Security 1 03-12-2004 10:32 PM


All times are GMT -5. The time now is 05:45 PM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration