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]
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]
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]
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]
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
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