Re: transferring databases
Hello, check if the files have to be in a special directory. check the datadir varible from show variables hope this helps samier. Myk MelezAn: abw [EMAIL PROTECTED] [EMAIL PROTECTED]Kopie:[EMAIL PROTECTED] Thema:Re: transferring databases 22.05.02 22:18 abw wrote: Is it possible to zip up database directories on one server and move them to another server, then simply unzip them? Yes. If so, once that is done, does something need to be done to mysql so it is aware of the databases? Is there some file that has a list of databases that must be updated or something? No. Mysql is running, because I see it in the process list, and from what the customer told me, he does see the databases, but he cannot access them. This is probably a file permissions problem. Make sure the user mysqld runs as (probably mysql) has access to the database directory and files (chown -R [name of mysql user] [directory name] should do the trick). -myk - 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: transferring databases
abw wrote: Is it possible to zip up database directories on one server and move them to another server, then simply unzip them? Yes. If so, once that is done, does something need to be done to mysql so it is aware of the databases? Is there some file that has a list of databases that must be updated or something? No. Mysql is running, because I see it in the process list, and from what the customer told me, he does see the databases, but he cannot access them. This is probably a file permissions problem. Make sure the user mysqld runs as (probably mysql) has access to the database directory and files (chown -R [name of mysql user] [directory name] should do the trick). -myk - 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: Transferring Databases
You need to login to the mysql client program and then use the source command: for example login with: mysql -u root -p once running type: source dumpfilename.sql If you can't do it this way, consider using an alternate GUI program like mysql-front (mysqlfront.de). That's it! Hope it helps. Craig Ostrander At 07:56 PM 4/13/2002, you wrote: Hi-- I'm trying to transfer information from a MySQL database on one server to a MySQL database on another server. I am using PHPMyAdmin. For small tables in the database, no problem. I just do the dump (data and structure) to a file. Then i either copy the contents of that file into the 'Run SQL query/queries' dialog box or upload it from the file using browse. Quick and easy. But for moderate size (e.g., 232 KB) files it's not working. The file dump is fine, but when i try to paste in the contents from the file into the dialog box it doesn't take. No error message or anything ... it just doesn't show (too big?). Also when i try to upload via the 'browse' option it doesn't work. Any ideas. there's gotta be a way to transfer these large data files ... that's what MySQL's all about, right? Thanks for the help, Chris - 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 === Craig Ostrander Blue Forest Software and Development Inc Database Design Consultants Worldwide MySQL // SAP DB // Oracle // Microsoft SQL Server // Microsoft Access Need help now? [EMAIL PROTECTED] or +1 530 326 5680 === spam filter: sql,query - 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