Wouter, Thursday, July 11, 2002, 2:23:55 PM, you wrote: WvV> * The mysql index and data files, can they be exchanged from a Windows WvV> Platform to Linux? Need they be prepared in some way maybe?
In general you can just copy files and then check permissions. But usage of mysqldump is more recommended. WvV> And how are the WvV> issues when just raw copying the files from one version to another (i.e. WvV> from version 3.23 to 4.x)? You can use your 3.23 databases on 4.0, too http://www.mysql.com/doc/U/p/Upgrading-from-3.23.html Up to me, I always make database backup. WvV> * something very different; when you are connected to mysql, is there some WvV> thing you can enter to change the user? Like the `su` command in linux? If you connected with mysql command-line client program - no. In C API take a look at function mysql_change_user(). This function presents also in PHP 3 ... -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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