import database
Hi all, how I can import in my PC a database Mysql that has been created in another PC and with other tools?
Re: import database
.here is one way http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html On Mon, Oct 10, 2011 at 4:47 PM, Jessica Bela jessicabel...@yahoo.comwrote: Hi all, how I can import in my PC a database Mysql that has been created in another PC and with other tools?
Re: import database
Jessica Bela jessicabel...@yahoo.com 10/10/2011 4:47 PM Hi all, how I can import in my PC a database Mysql that has been created in another PC and with other tools? Assuming the source and destination are BOTH mysql databases: mysqldump database export.sql ...creates a file 'export.sql'. Copy it to the target pc, then on the target mysql export.sql If the source database is something OTHER than MySQL, we'd need to know what that database is. CONFIDENTIALITY NOTICE: This message is directed to and is for the use of the above-noted addressee only, and its contents may be legally privileged or confidential. If the reader of this message is not the intended recipient, you are hereby notified that any distribution, dissemination, or copy of this message is strictly prohibited. If you have received this message in error, please delete it immediately and notify the sender. This message is not intended to be an electronic signature nor to constitute an agreement of any kind under applicable law unless otherwise expressly indicated herein.
Import Database from MySQL3.x to MySQL 4.x
Hello! I want to import a MySQL 3.x Databse to my new shiny MySQL4.x. I did a backup with /usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A mysql_lamp_backup.`date '+%Y.%m.%d'`.sql And i tried to import it to MySQL4.x with: /usr/local/mysql/bin/mysql -u root -p mysqlbak The error: ERROR 1064 at line 598: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-en' at line 1 This is teh line 598: CREATE DATABASE /*!32312 IF NOT EXISTS*/ blabla-en; IF i change the name to blabla_en, it works fine. Another issue: ERROR 1064 at line 830: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '! ,'poll','Questions','','',10,'r',11.61,11,10,0011,'','A'), ANd this 830 line ist just far to long to post it :) So do i have a general problem or what did i do wrong so far? Cheers, Mario -- COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test -- 1. GMX TopMail - Platz 1 und Testsieger! 2. GMX ProMail - Platz 2 und Preis-Qualitätssieger! 3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Import Database from MySQL3.x to MySQL 4.x
Mario Ohnewald [EMAIL PROTECTED] wrote: I want to import a MySQL 3.x Databse to my new shiny MySQL4.x. I did a backup with /usr/local/mysql-standard-4.0.14-pc-linux-i686/bin/mysqldump -u root -p --opt -A mysql_lamp_backup.`date '+%Y.%m.%d'`.sql And i tried to import it to MySQL4.x with: /usr/local/mysql/bin/mysql -u root -p mysqlbak The error: ERROR 1064 at line 598: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-en' at line 1 This is teh line 598: CREATE DATABASE /*!32312 IF NOT EXISTS*/ blabla-en; IF i change the name to blabla_en, it works fine. Use -Q option of the mysqldump. Another issue: ERROR 1064 at line 830: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '! ,'poll','Questions','','',10,'r',11.61,11,10,0011,'','A'), ANd this 830 line ist just far to long to post it :) So do i have a general problem or what did i do wrong so far? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [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]