Help! Problem moving MySQL data dir to a larger file system
I'm running MySQL (--ersion says mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)) on a RedHat Enterprise ES Release 4 system. The datadir was in it's own filesystem, mounted at /mysql, but it's now filled up (it's a 15 GB partition and it has 1.5 MB free). I shut down MySQL (did a kill `cat /mysql/mysql.pid` and waited for the daemon to exit), created a new directory (/z/mysql, in a filesystem with about 30 GB free), and verified that the files copied ok. I now try to restart mysql with /usr/local/bin/mysqld_safe --datadir=/z/mysql --pid-file=/z/mysql/mysql.pid /dev/null 21 . When I do a ps ax afterwards I don't see mysqld running. The host name is www2, so I looked in /z/mysql/www2.err and saw: 051107 00:32:49 mysqld started /usr/local/libexec/mysqld: File './www2-bin.46' not found (Errcode: 13) 051107 0:32:49 [ERROR] Could not use www2-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 051107 0:32:49 [ERROR] Aborting 051107 0:32:49 [Note] /usr/local/libexec/mysqld: Shutdown complete 051107 00:32:49 mysqld ended This confuses the crap out of me! I looked again in the /mysql directory, and there is no file named www2-bin.46 prewent. There is a www2-bin.45, and that same file is present in /z mysql and is the same size. So why is mysql looking for that non-existent file? And what do I have to do to make this work again? This is kind of a critical problem for us. -- Dan Mahoney [EMAIL PROTECTED] How you behave towards cats here below determines your status in Heaven. Robert Heinlein There are two means of refuge from the miseries of life - music and cats - Albert Schweitzer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help! Problem moving MySQL data dir to a larger file system
Hi Daniel, Check your permissions. Your mysqld process is probably trying to create the log file but can't and is telling you via the error code 13 message $ perror 13 System error: 13 = Permission denied $ Regards Daniel C. Mahoney wrote: I'm running MySQL (--ersion says mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)) on a RedHat Enterprise ES Release 4 system. The datadir was in it's own filesystem, mounted at /mysql, but it's now filled up (it's a 15 GB partition and it has 1.5 MB free). I shut down MySQL (did a kill `cat /mysql/mysql.pid` and waited for the daemon to exit), created a new directory (/z/mysql, in a filesystem with about 30 GB free), and verified that the files copied ok. I now try to restart mysql with /usr/local/bin/mysqld_safe --datadir=/z/mysql --pid-file=/z/mysql/mysql.pid /dev/null 21 . When I do a ps ax afterwards I don't see mysqld running. The host name is www2, so I looked in /z/mysql/www2.err and saw: 051107 00:32:49 mysqld started /usr/local/libexec/mysqld: File './www2-bin.46' not found (Errcode: 13) 051107 0:32:49 [ERROR] Could not use www2-bin for logging (error 13). Turning logging off for the whole duration of the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. 051107 0:32:49 [ERROR] Aborting 051107 0:32:49 [Note] /usr/local/libexec/mysqld: Shutdown complete 051107 00:32:49 mysqld ended This confuses the crap out of me! I looked again in the /mysql directory, and there is no file named www2-bin.46 prewent. There is a www2-bin.45, and that same file is present in /z mysql and is the same size. So why is mysql looking for that non-existent file? And what do I have to do to make this work again? This is kind of a critical problem for us. -- Dan Mahoney [EMAIL PROTECTED] How you behave towards cats here below determines your status in Heaven. Robert Heinlein There are two means of refuge from the miseries of life - music and cats - Albert Schweitzer -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[newbie] moving mysql db to new server
hi all, my machine crashed and i'd would like to restore my mysql databases on my new system. i'm having a backup of the entire drive, but no dump. my system is mac os x.3 server. is there a way to dragdrop some folders to my new system? thanks for your help :-) julien -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [newbie] moving mysql db to new server
2005/9/15, Julien vander Straeten [EMAIL PROTECTED]: hi all, my machine crashed and i'd would like to restore my mysql databases on my new system. i'm having a backup of the entire drive, but no dump. my system is mac os x.3 server. is there a way to dragdrop some folders to my new system? If you use MyISAM Table format, you could do that indeed. shutdown server Look for your MySQL Folder and just drag/drop the folders (the ones containing .frm, .MYD and .MYI files) in this directory (except mysql and test) into you new destination. restart server If it's InnoDB, I have no idea... thanks for your help :-) julien -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [newbie] moving mysql db to new server
Hello. i'm having a backup of the entire drive, but no dump. In what way have you done the backup of the drive? Do you have an archive with files from the corrupted drive or a raw image (snapshot) of the file system? If you have an archive you can just copy the data directory to the new system. However, both old and new systems and versions of MySQL should be compatible. For more details see: http://dev.mysql.com/doc/mysql/en/Moving.html http://dev.mysql.com/doc/mysql/en/upgrading-to-arch.html If you have a snapshot, extract the MySQL data directory from the image and do as it was described before. Julien vander Straeten [EMAIL PROTECTED] wrote: hi all, my machine crashed and i'd would like to restore my mysql databases on my new system. i'm having a backup of the entire drive, but no dump. my system is mac os x.3 server. is there a way to dragdrop some folders to my new system? thanks for your help :-) julien -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Moving MySQL data from Windows 4.0.12 to Linux 4.0.18
I am switching from a Windows computer to a Linux computer and when I dump the data from Windows to Linux I have no problem except for the fact that some of my characters have been converted to strange characters and when the data is displayed on a web page they show up as ?. I am sure that it has to do with character sets but I am not sure what to do about it. Any help would be appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18
On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote: I am switching from a Windows computer to a Linux computer and when I dump the data from Windows to Linux I have no problem except for the fact that some of my characters have been converted to strange characters and when the data is displayed on a web page they show up as ?. I am sure that it has to do with character sets but I am not sure what to do about it. Any help would be appreciated. I suspect you are using MySQL version 4 or later? I'm not sure how/what you are using to extract the data and display it on a web page but we had a similar problem after we upgraded from MySQL 3.23.18 to 4.0.18 and our experiences may be of some help to you. We use Macromedia Cold Fusion MX 6.1 with apache on Linux - as Cold Fusion is an ODBC-oriented environment, they supply the Merant ODBC driver for MySQL to connect the two. After the upgrade, things like the UK pound symbol and apostrophes in text fields were being displayed as black squares or '?' on a web page even though they appeared correctly if viewed with the mysql command-line client. After a lot of investigation I eventually found that I had to add a parameter like: useUnicode=truecharacterEncoding=Windows-1252 to the ODBC/MySQL driver which solved the problem. It sounds to me as if you have a similar problem in your environment although the fix in your case will be different. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18
I should have added what I was using to do the transfer. I am using phpmyadmin to do a dump to a gzipped file and then I am importing. Thanks for the info. -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 12:29 PM To: Lehman, Jason (Registrar's Office) Cc: [EMAIL PROTECTED] Subject: Re: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18 On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote: I am switching from a Windows computer to a Linux computer and when I dump the data from Windows to Linux I have no problem except for the fact that some of my characters have been converted to strange characters and when the data is displayed on a web page they show up as ?. I am sure that it has to do with character sets but I am not sure what to do about it. Any help would be appreciated. I suspect you are using MySQL version 4 or later? I'm not sure how/what you are using to extract the data and display it on a web page but we had a similar problem after we upgraded from MySQL 3.23.18 to 4.0.18 and our experiences may be of some help to you. We use Macromedia Cold Fusion MX 6.1 with apache on Linux - as Cold Fusion is an ODBC-oriented environment, they supply the Merant ODBC driver for MySQL to connect the two. After the upgrade, things like the UK pound symbol and apostrophes in text fields were being displayed as black squares or '?' on a web page even though they appeared correctly if viewed with the mysql command-line client. After a lot of investigation I eventually found that I had to add a parameter like: useUnicode=truecharacterEncoding=Windows-1252 to the ODBC/MySQL driver which solved the problem. It sounds to me as if you have a similar problem in your environment although the fix in your case will be different. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18
I had a situation you are seeing, what I ended up doing was create the db's in the new mysql server, setup replication, do LOAD DATA FROM MASTER let that run for a bit (while the first server is not in production of course) then after it synched up, shut down them both, removed the replication information and it started to work again. I may have copied the tables' files over, but I do not recall (~1.5years ago) HTH Thanks, James -Original Message- From: Lehman, Jason (Registrar's Office) [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 12:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18 I should have added what I was using to do the transfer. I am using phpmyadmin to do a dump to a gzipped file and then I am importing. Thanks for the info. -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 12:29 PM To: Lehman, Jason (Registrar's Office) Cc: [EMAIL PROTECTED] Subject: Re: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18 On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote: I am switching from a Windows computer to a Linux computer and when I dump the data from Windows to Linux I have no problem except for the fact that some of my characters have been converted to strange characters and when the data is displayed on a web page they show up as ?. I am sure that it has to do with character sets but I am not sure what to do about it. Any help would be appreciated. I suspect you are using MySQL version 4 or later? I'm not sure how/what you are using to extract the data and display it on a web page but we had a similar problem after we upgraded from MySQL 3.23.18 to 4.0.18 and our experiences may be of some help to you. We use Macromedia Cold Fusion MX 6.1 with apache on Linux - as Cold Fusion is an ODBC-oriented environment, they supply the Merant ODBC driver for MySQL to connect the two. After the upgrade, things like the UK pound symbol and apostrophes in text fields were being displayed as black squares or '?' on a web page even though they appeared correctly if viewed with the mysql command-line client. After a lot of investigation I eventually found that I had to add a parameter like: useUnicode=truecharacterEncoding=Windows-1252 to the ODBC/MySQL driver which solved the problem. It sounds to me as if you have a similar problem in your environment although the fix in your case will be different. Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving MySQl database
Check your ownerships and permissions. On Thu, 21 Aug 2003 00:27:05 +0800, Jon Miller used a few recycled electrons to form: | 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 I issue #/ /usr/share/mysql/mysql.server start | | Anyone have any idea what's gone wrong. I changed the datadir in both /etc/my.cnf and /usr/share/mysql/mysql.server. | | This is on a MySQL-3.23.55-1 server. | | Thanks | | Thanks | | Jon L. Miller, MCNE, CNS | Director/Sr Systems Consultant | MMT Networks Pty Ltd | http://www.mmtnetworks.com.au | | I don't know the key to success, but the key to failure | is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
moving MySQL
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, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving MySQL
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote: 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? Yes, if you can afford to turn off your server. If you need to keep your server live, then things become more complicated, but solvable... Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: moving MySQL
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote: 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? Yes. If you're on a Unix-like platform, you can symlink one or more database directories to another disk. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 947,126,092 queries (572/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: moving MySQL
Sure, just shut down the database cleanly (mysqladmin shutdown), move the data directory intact to the new filesystem, and start up again. --Michael -Original Message- From: Jon Miller [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 8:41 AM To: [EMAIL PROTECTED] Subject: moving MySQL 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, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
moving MySQl database
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 I issue #/ /usr/share/mysql/mysql.server start Anyone have any idea what's gone wrong. I changed the datadir in both /etc/my.cnf and /usr/share/mysql/mysql.server. This is on a MySQL-3.23.55-1 server. Thanks Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au I don't know the key to success, but the key to failure is trying to please everybody. -Bill Cosby -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: moving MySQL
If you can't turn off your db use mysql_hotcopy and copy the data over NFS ---Original Message- --From: Brian Reichert [mailto:[EMAIL PROTECTED] --Sent: Wednesday, August 20, 2003 2:24 PM --To: Jon Miller --Cc: [EMAIL PROTECTED] --Subject: Re: moving MySQL -- --On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote: -- 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? -- --Yes, if you can afford to turn off your server. -- --If you need to keep your server live, then things become more --complicated, but solvable... -- -- -- Thanks -- -- Jon L. Miller, MCNE, CNS -- Director/Sr Systems Consultant -- MMT Networks Pty Ltd -- http://www.mmtnetworks.com.au -- -- I don't know the key to success, but the key to failure -- is trying to please everybody. -Bill Cosby -- --Brian 'you Bastard' Reichert [EMAIL PROTECTED] --37 Crystal Ave. #303 Daytime number: (603) 434-6842 --Derry NH 03038-1713 USA BSD admin/developer at large -- --MySQL General Mailing List --For list archives: http://lists.mysql.com/mysql --To unsubscribe: --http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Moving MySQL data to RAMDisk
On moving my data files from /var/lib to /mnt/ramdisk I seem to be missing something. I've changed every .ini and .conf file I can find (/etc/my.cnf, /etc/init.d/mysql, /etc/init.d/mysqld, /etc/php.ini and /etc/httpd/conf/httpd.conf (for DAV-lock)). MySQL seems to start ok, but when I use my application through Apache the error message is that MySQL is not running (I think it's just not finding it). Any suggestions? Creigh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Moving MySQL data to RAMDisk
MySQL is pretty good about following symlinks. Move /var/lib/mysql to /mnt/ramdisk/mysql and then symlink to it. # ln -s /mnt/ramdisk/mysql /var/lib/mysql Changing where everything resides in my.cnf should have been sufficient but the symlink way works great as well. And there should be no performance hit. I'm fairly certain I've read in the docs that it traverses a symlink to it's source directory and proceeds to access the files there instead of hitting the symlink every time. Also, take PHP out of the loop at first. Try accessing it via the command-line mysql client first and after you get that working, then introduce extra variables like apache/php into the mix. PS. Check permissions as well.. /mnt/ramdisk/mysql needs to very closely match the permissions of /var/lib/mysql (as well as owner/group). -Original Message- From: Creigh Shank [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 8:35 AM To: MySQL Users Subject: Moving MySQL data to RAMDisk On moving my data files from /var/lib to /mnt/ramdisk I seem to be missing something. I've changed every .ini and .conf file I can find (/etc/my.cnf, /etc/init.d/mysql, /etc/init.d/mysqld, /etc/php.ini and /etc/httpd/conf/httpd.conf (for DAV-lock)). MySQL seems to start ok, but when I use my application through Apache the error message is that MySQL is not running (I think it's just not finding it). Any suggestions? Creigh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Moving Mysql
Hello everyone, I have my MySQL database n the var partition of a FreeBSD server. The problem is that the partition is almost full, and now I can't start the SQL server! I am thinking of moving the MySQL data directory to another partition, but I don't know how I should do this. Can anyone please tell me how, and also do I have to change any settings after moving the data directory? Thanks so much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Moving Mysql
Hello, First shutdown mysql. The move or copy databses to new directory. Restart server using --datadir=/my/path/for/data or place info in my.cnf file. (See examples provided with MySQL code). Ken - Original Message - From: Soheil Shaghaghi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:41 PM Subject: Moving Mysql Hello everyone, I have my MySQL database n the var partition of a FreeBSD server. The problem is that the partition is almost full, and now I can't start the SQL server! I am thinking of moving the MySQL data directory to another partition, but I don't know how I should do this. Can anyone please tell me how, and also do I have to change any settings after moving the data directory? Thanks so much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Moving Mysql
Soheil Shaghaghi wrote: Hello everyone, I have my MySQL database n the var partition of a FreeBSD server. The problem is that the partition is almost full, and now I can't start the SQL server! I am thinking of moving the MySQL data directory to another partition, but I don't know how I should do this. Can anyone please tell me how, and also do I have to change any settings after moving the data directory? Thanks so much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Soheil, If you have a partition that you can dedicate to mysql, just rename the current mysql directory, mount the dedicated partion as /var/lib/mysql/ and copy the files from the mysql directory you renamed . Of course, be sure to stop mysql and check permissions of the new location. walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
plan: moving mysql db to a fresh server! (help?)
Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for pc-linux-gnu (i686) my db(var) resides in /usr/mysql/var/. I have this new server which i have mysql too. Now what im thingking about is, instead of dumping all database/tables on my old redhat server. Compressing and moving it all */var/* to my new server's */var/* directory. What do u think? = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: plan: moving mysql db to a fresh server! (help?)
At 10:36 +0800 8/15/02, louie miranda wrote: Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for pc-linux-gnu (i686) my db(var) resides in /usr/mysql/var/. I have this new server which i have mysql too. Now what im thingking about is, instead of dumping all database/tables on my old redhat server. Compressing and moving it all */var/* to my new server's */var/* directory. What do u think? Sure. You might need to adjust some of the Host values in your grant tables, if they refer to the current server host by its name or IP number rather than as localhost or 127.0.0.1. = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: plan: moving mysql db to a fresh server! (help?)
salamat kabayan!! thnx! = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:02 AM Subject: RE: plan: moving mysql db to a fresh server! (help?) I think its...okey R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No. (Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From: louie miranda [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:37 AM To: [EMAIL PROTECTED] Subject: plan: moving mysql db to a fresh server! (help?) Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for pc-linux-gnu (i686) my db(var) resides in /usr/mysql/var/. I have this new server which i have mysql too. Now what im thingking about is, instead of dumping all database/tables on my old redhat server. Compressing and moving it all */var/* to my new server's */var/* directory. What do u think? = Thanks, Louie Miranda... WebUrl: http://axis0.endofinternet.org Email: [EMAIL PROTECTED] - [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Moving MySQL database(s)
Hi, I've developed my mysql databases/tables on a local intranet server. What's involved in correctly copying them to an online linux machine please? regards, Graham Nichols
Re: Moving MySQL database(s)
"Graham Nichols" [EMAIL PROTECTED] wrote: I've developed my mysql databases/tables on a local intranet server. What's involved in correctly copying them to an online linux machine Stop the mysql server on the intranet and FTP the files in the MySQL data directory to the MySQL data directory on the destination machine. OR While the mysql server is still running, use "mysqldump" to create a dump file of SQL command that can be piped to MySQL to recreate the tables, then FTP them to the destination machine and pipe the dump files to MySQL. Search the list archives and manual for more info. This has been covered a lot. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php