473,327 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Moving a MySql database

Hi.

Please there is a way to move an entire MySql DB from a Linux box to
another Linux box using some PHP statements or using some program wich
is capable to do this?

Thank you from Franco.
Jul 17 '05 #1
7 1822
Franco Fellico' wrote:
Hi.

Please there is a way to move an entire MySql DB from a Linux box to
another Linux box using some PHP statements or using some program wich
is capable to do this?

Thank you from Franco.


Try a sqldump, thats why they were invented, RTFM thnx and if you dunno
what RTFM means google it
Jul 17 '05 #2
Franco Fellico' wrote:
Hi.

Please there is a way to move an entire MySql DB from a Linux box to
another Linux box using some PHP statements or using some program wich
is capable to do this?


http://www.phpmyadmin.net/

--
If the Internet is a Marx Brothers movie, and Web, e-mail, and IRC are
Groucho, Chico, and Harpo, then Usenet is Zeppo.
Jul 17 '05 #3
Franco Fellico' wrote:
Please there is a way to move an entire MySql DB from a Linux box to
another Linux box using some PHP statements or using some program wich
is capable to do this?


http://dev.mysql.com/doc/mysql/en/Backup.html

--
USENET would be a better place if everybody read: : mail address :
http://www.catb.org/~esr/faqs/smart-questions.html : is valid for :
http://www.netmeister.org/news/learn2quote2.html : "text/plain" :
http://www.expita.com/nomime.html : to 10K bytes :
Jul 17 '05 #4
Franco Fellico' wrote:
Hi.

Please there is a way to move an entire MySql DB from a Linux box to
another Linux box using some PHP statements or using some program wich
is capable to do this?


If both boxes use the same version of mySQL then you can simply copy the
files (after stoppping the mySQL servers). I do this for quick-and-dirty
backups, short script; stop server, copy files to new location, start
server.
Jul 17 '05 #5
Kevin Thorpe wrote:
Franco Fellico' wrote:
Hi.

Please there is a way to move an entire MySql DB from a Linux box to
another Linux box using some PHP statements or using some program wich
is capable to do this?

If both boxes use the same version of mySQL then you can simply copy the
files (after stoppping the mySQL servers). I do this for quick-and-dirty
backups, short script; stop server, copy files to new location, start
server.


I believe it also works for differing platforms too, and in some cases,
even differing versions...

randelld
Jul 17 '05 #6
Franco Fellico' wrote:
Hi.

Please there is a way to move an entire MySql DB from a Linux box to
another Linux box using some PHP statements or using some program wich
is capable to do this?


On the originating box:
$ mysqldump -cCel -u username -p dbname > dump.sql

On the target box:
$ mysqladmin -u username -p create dbname
$ mysql -u username -p dbname < dump.sql

--
http://www.ninja.up.ac.za
Jul 17 '05 #7
"Franco Fellico'" <ff******@inwind.it> wrote in message
news:d8**************************@posting.google.c om...
Hi.

Please there is a way to move an entire MySql DB from a Linux box to
another Linux box using some PHP statements or using some program wich
is capable to do this?


I use SQLyog (available at www.webyog.com). You can connect to the two
databases and it will copy the structure and data for you. You have to buy
it, though.

However, you can do this just easily using free software or even just the
mySQL utilities as have been pointed out in this thread.

- Virgil
Jul 17 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Jon Miller | last post by:
We've run out of disk space and would like to move either the entire MySQL = system or if possible move the databases. Can this be done without any = difficulties? Thanks Jon L. Miller,...
0
by: Jon Miller | last post by:
I've tried moving the database from one partition to another and now I'm = getting the following error: # Starting mysqld daemon with databases from /data/mysql 030820 23:48:08 mysqld ended When...
4
by: Stephen Ghelerter | last post by:
I am moving a web site with a MySql database to another server. Can I create a database on the new server with the same name and then move the tables there, or is life not that simple? Or can I...
0
by: Terry | last post by:
I am trying to move a datbase from one machine to another. I have tried two different methods and neither are working. First I tried using : >> mysqldump dbName > backup_file.sql >> mysql...
3
by: Rock2005 | last post by:
Hi All, I have a hard drive that fails to boot with some mysql 4.1 data I would like to keep. Have slaved that drive to another PC (with mysql 4.1.12 loaded) and have saved other data and am able...
2
by: Lakigam | last post by:
Hello - I have 2 identical tables in the same MySQL database - I want to copy some content of the first one to the second one Any idea how to do this without using INSERT the DELETE ??? ...
2
by: moller | last post by:
Im looking in to the possibility of moving from mySQL to an access database. My reasons are: (1) Database is single user. (2) Database local on users PC. (3) Database has only 8 tables where 4...
9
by: Daven Thrice | last post by:
If I have a fairly big Access MDB, that is relational, and has, say, 100 objects (forms, reports, modules, etc.), what is the path to get this database "online". Is there a way to put the tables...
34
by: Karam Chand | last post by:
Hello I have been working with Access and MySQL for pretty long time. Very simple and able to perform their jobs. I dont need to start a flame anymore :) I have to work with PGSQL for my...
3
by: Thiagu.M | last post by:
Hi All i dont have much experience in databases or Mysql.i have my data in development m/c with Mysql 4.1.12, i have to move them to production m/c with Mysql 5.0.3 .when tried it showed error...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.