Import Database From MySQL3.x To MySQL 4.x
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,00100 00000010000,'','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
View Complete Forum Thread with Replies
Related Forum Messages:
Import Of Database In Mysql
I get this error when I am importing the database. What am I doing wrong? ERROR 1064 at line 625735: You have an error in your SQL syntax near ' begin_excerpt varchar(250) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM' at line 5
View Replies !
What Database Do You Use To Import Into MySQL
I am setting up a MySQL database and find phpmyadmin very slow to enter data, so I am thinking of importing all the data from Microsoft Access 2003 instead. Or I could create a php page to enter the data. What do you guys use as your main database to import into MySQL?
View Replies !
Import Old Data To New Mysql Database
My machine was down before, fortunately I have back up the whole /usr/local/mysql directory. Now I have setup a new mysql on a new machine, how can I import the old data back to the new database?? My old mysql version: mysql-3.22.32 new mysql version: mysql-max-4.0.3-beta-sun-solaris2.7.sparc I used to run the mysql like this: /usr/local/mysql/bin/mysql abc should I add the user abc to my new database first? and how?
View Replies !
Export/Import MySQL Database
I am writing an application usig PHP/MySQL on my local development box. Now that the app is complete, I am ready to move it into production and live on the domain. What is the best way to go about moving that database from the local MySQL platform onto my hosting?Should I export it into a SQL file and rebuilt it on the host?
View Replies !
How Do I Import .csv File Into My Mysql Database?
I woould like to know how to import csv files into my mysql databse, I tried the: LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '' Commands but I dont know where would i put these command and wher do put the "importfile.csv", what directory and location?
View Replies !
Import .xls File Into A Mysql Database
I have a .xls file that i would like to import into a mysql database, I am ok creating the mysql table in phpmyadmin on my webspace but i cant work out or find any useful tutorials on how to import the database from the .xls format and get it into the database short of building a form and submitting by hand which would take far to long.
View Replies !
Import Excel File Into Mysql Database
I was looking for information on how to import an excel file or other text file into a MySql database. I have done this with both access and SQL Server and am looking for a way to do this in MySql. I have several hundred items i want to import into a parts database that is currently in an excel file but can be saved as comma separated or other format.
View Replies !
Import Excel Data Into Mysql Database
I am new to MYSQL..I have a excel sheet with 4 colums and several rows of data.. I need to import all these into a database which i have created in mysql..I tried using LOAD DATA LOCAL INFILE 'D:student.xls' INTO TABLE test.student FIELDS TERMINATED BY ' ' ENCLOSED BY '' ESCAPED BY '' LINES TERMINATED BY ' '; But i get error saying Data truncated at column'x'..
View Replies !
Import A Directory Of Text Files Into A Mysql Database With Php?
I have a directory of text files that i'd like to import into a msql table... I was wondering if there's an easier way to do this with php/mysql, I'd like to avoid copy/pasting the entire directory (thousands of files) into the database if i can. The directory structure of the text files resembles... somepath/A/Aerosmith/Song Name.txt - (extention varies) What i'd like to do is use php to scan the directory and input the file path information and the content from each file into a table like... Dir Artist Song Text Type ------------------------------------------------------------------------ A Aerosmith Song Name Fa La La La La (example text) File Ext B Beatles Song Name Fa La La La La (example text) File Ext
View Replies !
Import Excel Sheet Datas To A Mysql Database
I have a dotnet application in which i have to import data from an excel sheet and store datas in mysql table to display those datas in my dotnet application. Iam using this datas to display datas for generating employee salary slip in my dotnet application. pls do help me with source code in C#.
View Replies !
Database Import
Well I wanted to xfer the database over to a new site.. so I went to 'export' to save the database and saved it was eqdkp.txt As soon as I did that the old site (where the database was) said "unable to connect to database" .. not sure why, so I went in and ensured my "export" saved all the correct data.. (it did) then I decided it would be best to clear out the databases and import them back thinking that may fix it Well I went to import it and it says Can't create database 'plieber_eqdkp'. Database exists I can not for the life of me figure out how to get it to import back into the database!
View Replies !
Database Recovery And Import
I've been given the job of recovering a database. It's mysql, version unknown but i'd suspect probably 3 maybe 4 certainly not 5. Apparently the host provider where this was didn't set up the backups right, because the guy gave me the db files not database dumps and i am uncertain what to do with them. I'd like to bring them in to a mysql installation and take a look at the data contained. If it's valid i.e. what has been requested i'd like to do a mysqldump on it, then import it in to the guy's database. He says he wants the entry.db which contains three years worth of nonbacked up data. He sent me an archive, one of which is a file entry.db so it appears the files are good, i'm just not sure how to get at them. I've got .db, .db.loc, .idx, and .idx.loc files so it looks like i've got a complete package. Any suggestions?
View Replies !
Import Large Database
I saved my website databgase to my home computer. I am setting up a local version of the site, and need to import the database. I have mysql and everything set up. But when I try to run the sql script that I exported from my site's control panel, I get an out of memory error. What is the proper way to import this database? Do I need to increase some memory setting?
View Replies !
Import Data From Database
I need to convert data in a MYSQL database into a format that Microsoft Access can accept. I need a SQL statement to import the data from the existing mySQL database to Microsoft Access
View Replies !
Import Schema Database
I am installing ECM Drupal and I need to import schema, tables, etc I downloaded file "database.4.0.mysql" How to import it to my MySql????????
View Replies !
Phpmyadmin :: Import Access Database
i have a access database that wich i want to convert to mysql. first, using Access i export it to .txt after that i try to import it using phpmyadmin and it keeps saying "file could not be read" i did the same with an excel file converting it first to CSV (comma separeted value) and then when importing it to phpmyadmin i get the same error.
View Replies !
Database Import For Invision Board
I've had to switch hosts and have been using Invision Power Board on the old host. When i tried to switch to the new host I discovered that they had an older version (1.2) and that everytime I tried to import the database they would return multiple errors, even if I dropped tables beforehand on the newly set up board. Can I transfer the data to this new board? Is it possible for me to just transfer the individual table information? Can I even tansfer the information to a new php-based board?
View Replies !
Import Only 1 Database From A Mysqldump File
i like to import only one Database include 37 Tables from a dumpfile. But i must be shure that only this one Database is imported. The dumpfile include more Databases (70) with >1500 Tables Can i use this --database=onlyforum option for mysql ? mysql -hlocalhost -uuser -p --database=onlyforum < alldatabases.sql ore is there a other option to use?
View Replies !
Import Some Tables Into Another Pre-existing Database
I want to dump all but 6 tables of a database into a sql file. THe below is all but those six tables (do I have to wrote out all the table names??) mysqldump -u root -p --opt dbname --tables view_history top_level_feed tag_set pending_tag_set pending_tag pending_fact namespaced_predicate main_search_ns_pred main_search_keywd_pred main_search_keywd_ns_pred main_search_facets main_search_descr_pred main_search_descr_ns_pred job_watcher job_log_entry item_address_watcher feed_watcher feed_log_entry feed_group feed entity_type_sample_uri entity_type dw_user content_search_ns_pred content_search_facets colleague_search_ns_pred cnt_search_keywd_pred cnt_search_keywd_ns_pred cnt_search_descr_pred cnt_search_descr_ns_pred browse_trigger_pred browse_trigger_ns_pred browse_template browse_ns_pred auto_feed > dbNameTables917.sql Then import them into another database that has all these tables already. I want to overwrite these tables with new data from the dump. Will the mysqldump utility work or should I use the mysqlimport dbname --lock-tables --delete /path/to/sqlfile.sql work?
View Replies !
Database Import To Over Ride Tables
I am generating auto-backups from simple database dumps. I'm then trying to import these on a regular basis (1 per week) into my test database through a auto-import script using PHP. The problem I am having is that I can't seem to import into a database with the existing database table structures as it says 'Table already exitsts etc'. Is there a way when dumping the database I can specify 'if table exisits, drop and insert' similar to when you specify the requirement when exporting the datbase from phpmyadmin? I would prefer not dropping the database and regenerating it each time.
View Replies !
How To Import Excel File Into An Already Normalized Database?
I have a problem with the issue in the subject, i have all data in one big excel file, in a denormalized form, and on the other side, i have mysql database with many tables, which is already in production, and it is of course in the 3rd NF. How do i go about importing that excel file , is there any good tool i could use to handle prim/foreign key issues for me?
View Replies !
Import Database Overwrite And Data Elimination
When I imported files from one mysql database to another,I got no error messages, so the import was successful, but it also eliminated the information I had in the database into which I was importing. I thought the information would just be added to the information that was already existing. Any ideas of what could have happened?
View Replies !
Import Original Database Files After Clean Install
I am wondering how to import database files stored on a seperate partition into a brand-new MySQL installation. I do not have the old MySQL installation because this is a clean install of XP. I have the actual database folders and table files (the ".frm" and ".opt" files) stored on a seperate partition which were created by a different MySQL installation. Is there a way to do this so the MySQL client will see them? I tried configuring a new datadir and copying the old MySQL data folders and files into the new datadir but that didn't work -- MySQL only sees the default databases created during installation.
View Replies !
Import XML Into MySQL
Sorry. I missed this discussion previously. Now I need the answer. Figures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=...sie.nctu.edu.tw
View Replies !
MySQL Import CSV
I've been going nuts trying to import a CSV that has dates. I've tried everything I can think of. Below are the formats I've tried. "Data 1", "Data 2", 12/26/2005, ..... "Data 1", "Data 2", "2005/12/26", ..... "Data 1", "Data 2", "2005-12-26", ..... How do you do it
View Replies !
Mysql Import
when should I use mysqlimport, or load data and when should I write my own Perl parser to help load the table? What criteria would be needed to decide to read a file into a hash?
View Replies !
Import Into MySQL
I need to be able to automate the import of a .sql or .csv file into my MySQL database. I am currently having a file dropped on my server from a distribution program externally every 15 minutes, so preferably I would like to import the file every 15 minutes also. Is this possible using a cron job? Or using Perl or PHP?
View Replies !
Import Dump From Unix Mysql To Windows Mysql
I am trying to load a dump from a MySQL database on my ISP's server to my development environment on a Win 2K machine (running MySQL). When I run the mysql command to run the load script, MySQL gives the following complaint: "ERROR 1064 at line 21: You have an error in your SQL syntax. Check the manual t hat corresponds to your MySQL server version for the right syntax to use near 'D EFAULT CHARSET=latin1' at line 7" The dump from the ISP's server is created using mysqldump. The ISP is running MySQL 4.1.20. My development environment is MySQL 4.0.26. I have no problem loading dumps made from my development environment usng phpmyadmin.
View Replies !
MySQL Export/import
I have installed MySQL on my Linux Mandrake 10 workstation; I didn't change any default values (except for the user-accounts). I used a CMS to create a website which I want to upload to my hosting provider. When I export my database (using PHPMyAdmin) from my workstation to a local file and then on the server (again using PHPMyAdmin) I import the database from the local file, some characters are 'fucked up'. My local install is MySQL 4.1.2-alpha-standard (from Mandrake RPM) and it seems that the default character set is utf8 with collation utf8_general_ci. But some columns in my tables (even within other databases) use collation latin1_swedish_ci (strange..). The server install is MySQL 4.0.15. Using mysqladmin with the 'variables' command, I found out that variable 'character_set' has value 'latin1' and the variable 'character_sets' has value: latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 The 'convert_character_set' variable seems to have no value. I tried creating a database on the server using mysqladmin with the --default-character-set=utf8, but that also doesn't help. (it doesn't give any error message, but utf8 is not listed in the 'character_sets' variable).
View Replies !
Import Users From Old Mysql Db?
I'm trying to import all of the info in the mysql database (ya know the db that keeps track of all the users and what they can and cannot do). I tried just a standard mysqldump from the old box. Copy the file over to the new box. And do a mysql -uroot -p < /tmp/mysqldb.sql. Lo and behold it doesn't work. Looks like there are more columns in some of the tables.
View Replies !
Import From Excel To MySQL
I have multiple spreadsheets in Excel format and in .csv format too, that I would like to possibly import to a mysql database. All of the excel and csv files have is one huge colum and they are only 1 cell on each line. An estimate of 7k-8k domain names I need to run a whois on. Basically I need a way to import them from the Excel sheet to the database so at that point I can manipulate the data and use a php script of some sort to run a whois after extracting the domain name, and then return the results to the database and have it attached to the domain name.
View Replies !
Mysql Import CSV Query
I am using the following command to import a csv file into my MySQL database but for some reason the first column in the CSV file is being ignored. Any thoughts as to why this might be happening? Asked this in the Win32 forum before realising that might be the wrong place to ask... /usr/bin/mysqlimport -d --fields-terminated-by=, --user=root -p databasename solicitors.csv
View Replies !
Import Data Into Mysql
is there a way around it, other than scrubbing the data ? currently, the dates are in mm/dd/yyyy format if i want to use in import file with fields that have this format, is there any way of applying a conversion to that field on the fly ?
View Replies !
MySQL Import On WAMP
I installed WAMP on XP to use a test server and can't figure out this silly windoze command line thing for MySQL. It seems my linux commands are Klingon to Windows. I try this.. mysql> username -p database < c:wampwwwfile.sql and I get a bunch of syntax errors. I tried dual slash and everything and it's not working. The file is 80MB so it has to be done at the command prompt. Is there anyone out there? Is there anyone listening? I've searched low and hi and there doesn't seem to be a page with how to do this. I've seen LOAD but that's just for a table.
View Replies !
Paradox Import Into MySQL
I am trying to import some paradox .db files into my MySQL database, and I would like to know how to do this from the MySQL command line so I can create a batch file. Does anyone know the syntax on how to do this?
View Replies !
Import List To MySql
I have been manually inputting an alpabetical list into MySql via a PHP submit form. I have a lot of data to enter and doing it one by one is killing me! Is there a way to import the list without having to do it individually? Here's an example. Under my Sub category INSERT INTO `my_categories` VALUES (7715, 'Bala', 7711, NULL, 0.00); INSERT INTO `my_categories` VALUES (7716, 'Balmy', 7711, NULL, 0.00); etc, etc.
View Replies !
|
TRACKER
