Re: Win & Linux
Ivan Cukic (Foment) escribio': -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Another question how can see the compatibility of authentification? | I don't know. It should be written in docs... Anyway, try the next thing... Try to create a symlink for every db except for mysql. create a symlink /var/lib/mysql/db1 -> /mnt/onedisc/Program\ Files/mysql/data/db1 create a symlink /var/lib/mysql/db2 -> /mnt/onedisc/Program\ Files/mysql/data/db2 create a symlink /var/lib/mysql/db3 -> /mnt/onedisc/Program\ Files/mysql/data/db3 this way you can control which databases will be shared between win and lin. Regards, Ivan -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAlmSuTGB93IULb3YRAmt1AJ4wyI31vgXS/OwdpkxerolyfLdpiQCfZcFW PZ26ss5LaXM9KFosh2PEd8Y= =pdaD -END PGP SIGNATURE- Thanks, it works, but I needed change privileges and append the new databases. Regards, Segismundo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Win & Linux
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | Another question how can see the compatibility of authentification? | I don't know. It should be written in docs... Anyway, try the next thing... Try to create a symlink for every db except for mysql. create a symlink /var/lib/mysql/db1 -> /mnt/onedisc/Program\ Files/mysql/data/db1 create a symlink /var/lib/mysql/db2 -> /mnt/onedisc/Program\ Files/mysql/data/db2 create a symlink /var/lib/mysql/db3 -> /mnt/onedisc/Program\ Files/mysql/data/db3 this way you can control which databases will be shared between win and lin. Regards, Ivan -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAlmSuTGB93IULb3YRAmt1AJ4wyI31vgXS/OwdpkxerolyfLdpiQCfZcFW PZ26ss5LaXM9KFosh2PEd8Y= =pdaD -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Win & Linux
Hi, Ivan and all! Tanks, but create a symlink from... to? Another question how can see the compatibility of authentification? I'm not very experiency on Linux and Mysql. Thanks, Segismundo |You can create a symlink. |Have you tested compatibility between MySQL 5 and 4 concerning |authentification? |You should install the same versions even if it doesn't fix this error. |Ivan >Hi all! >I want you to present this question: >1) I'm working finely with Mysql 5 over W2k without problems on Disk1. >My datadir is on Disk2. Ok. >2) One mounth ago, i've installed Linux (Debian) and yesterday i've >instaled mysql 4.00 on a partition of the Disk1. Without problems. >3) I'm trying to change the datadir of 'my.cnf' to my database of mys >Disk2 and when i reboot, Mysql server says "Can't connect to localhost >Mysql server". Change the previous my.cnf, restart mysql server and >connect ok. >4) My question is: Is it possible that de datadir was the same to Win >and Linux because i can't duplicate my databases? The disk2 is read and >write. If it is possible, how? >Reggards, >Segismundo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Win & Linux
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | | 4) My question is: Is it possible that de datadir was the same to | Win and Linux because i can't duplicate my databases? The disk2 is | read and write. If it is possible, how? You can create a symlink. Have you tested compatibility between MySQL 5 and 4 concerning authentification? You should install the same versions even if it doesn't fix this error. Ivan - -- To mess up a Linux box, you need to work at it; to mess up your Windows box, you just need to work on it. - - Scott Granneman, Security Focus -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAk4MDTGB93IULb3YRAnmjAKCA/OYTxhHwKDhxrcsVk9trcttXBQCfSe4n pzotE7mWlxu9zEet6KmP5O4= =ayfv -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Win & Linux
Hi all! I want you to present this question: 1) I'm working finely with Mysql 5 over W2k without problems on Disk1. My datadir is on Disk2. Ok. 2) One mounth ago, i've installed Linux (Debian) and yesterday i've instaled mysql 4.00 on a partition of the Disk1. Without problems. 3) I'm trying to change the datadir of 'my.cnf' to my database of mys Disk2 and when i reboot, Mysql server says "Can't connect to localhost Mysql server". Change the previous my.cnf, restart mysql server and connect ok. 4) My question is: Is it possible that de datadir was the same to Win and Linux because i can't duplicate my databases? The disk2 is read and write. If it is possible, how? Reggards, Segismundo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: WIN/Linux Compatibility
> > I don't believe this is possible, but I couldn't find any posts and wanted > > to confirm. I realize that we may need to import through an SQL query. > > I believe itis, you can just copy the files over. > > Thanks for the tips! I will let the list know how this turns out! Alex Charlton [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: WIN/Linux Compatibility
Alex, What I do is a DUMP on the table, either the schema or data or both. This will create a .sql file you can run again against whatever platform you are on -Original Message- From: Alex Charlton [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 17, 2002 3:55 AM To: mySQL Subject: Fw: WIN/Linux Compatibility Hi all, I was wondering if there is any chance that table information is compatible between Windows and Linux? IE. If I copy windows data files to a linux server, can mySQL on the linux server read this data? I don't believe this is possible, but I couldn't find any posts and wanted to confirm. I realize that we may need to import through an SQL query. Thanks in advance. Alex Charlton [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
Re: Fw: WIN/Linux Compatibility
On Sun, 2002-02-17 at 02:54, Alex Charlton wrote: > Hi all, > > I was wondering if there is any chance that table information is compatible > between Windows and Linux? Hi Alex, MyISAM tables are (mostly) OS and platform independent. You should be able to copy them between Linux and Windows without changes See http://www.mysql.com/doc/M/y/MyISAM.html If you are using another type of table, please check the relevent section of the MySQL documentation. Ciao! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada <___/ www.mysql.com 403.244.7213 - 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
Fw: WIN/Linux Compatibility
Hi all, I was wondering if there is any chance that table information is compatible between Windows and Linux? IE. If I copy windows data files to a linux server, can mySQL on the linux server read this data? I don't believe this is possible, but I couldn't find any posts and wanted to confirm. I realize that we may need to import through an SQL query. Thanks in advance. Alex Charlton [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: Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux
Or, you could take Grigory's suggestion a step further and make a shell script ... # #!/bin/sh # $1 - Windows filename with extension (case counts) # $2 - Unix filename with extension (case as you want it) cat $1|tr -d '\r' >$2 # - Original Message - From: "Grigory Bakunov" <[EMAIL PROTECTED]> To: "Fred Dinkler" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, July 14, 2001 1:15 PM Subject: Re: Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux Date |Sat, 14 Jul 2001 13:34:40 -0400 >From |"Fred Dinkler" <[EMAIL PROTECTED]> Hello! FD> Creating and editing dbdump SQL files from local dev in Win2k, moving to FD> Linux for QA and production. FD> Text files edited using Wordpad and Notepad have extraneous line-end chars FD> (bold M). FD> Any suggestions on configuration of any Win editor to save text without FD> garbage chars showing up on Liux side? You can also use simple script like this cat your_windows_file|tr -d '\r' >your_unix_file Truly yours, Grigory Bakunov ASPLinux Support Team http://www.asplinux.ru - 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 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux
Date |Sat, 14 Jul 2001 13:34:40 -0400 >From |"Fred Dinkler" <[EMAIL PROTECTED]> Hello! FD> Creating and editing dbdump SQL files from local dev in Win2k, moving to FD> Linux for QA and production. FD> Text files edited using Wordpad and Notepad have extraneous line-end chars FD> (bold M). FD> Any suggestions on configuration of any Win editor to save text without FD> garbage chars showing up on Liux side? You can also use simple script like this cat your_windows_file|tr -d '\r' >your_unix_file Truly yours, Grigory Bakunov ASPLinux Support Team http://www.asplinux.ru - 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: Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux
Date |Sat, 14 Jul 2001 13:34:40 -0400 >From |"Fred Dinkler" <[EMAIL PROTECTED]> Hello! FD> Creating and editing dbdump SQL files from local dev in Win2k, moving to FD> Linux for QA and production. FD> Text files edited using Wordpad and Notepad have extraneous line-end chars FD> (bold M). FD> Any suggestions on configuration of any Win editor to save text without FD> garbage chars showing up on Liux side? You can also use simple script like this cat your_windows_file|tr -r '\r' >your_unix_file Truly yours, Grigory Bakunov ASPLinux Support Team http://www.asplinux.ru - 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
Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux
Creating and editing dbdump SQL files from local dev in Win2k, moving to Linux for QA and production. Text files edited using Wordpad and Notepad have extraneous line-end chars (bold M). Any suggestions on configuration of any Win editor to save text without garbage chars showing up on Liux side? Thanks, Fred Atlanta - 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