MySQL Old Dump Files

2014-10-14  Source: Original Site  Category:MySQL  Views:0 


I've inheritied a mysql dump from a 3.23 database. The appliance I'm supposed to reload it on is a 4.1 mysql database. it's bombing out on me, which really doesn't surprise me. However, I'm wondering if there is a script out there that will go through and check the syntax of the .sql file and convert any 'non 4x' statements into something that 4.1 can understand and like.

It's not a giant DB, it's about 250kb - but that's a lot of flat text to have to go bumbling though since I'm not really sure what the differences are. The error I'm running into is this:

ERROR 1064 (42000) at line 286: 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 'version(version),
KEY component(component),
KEY resolution(resolution),
KE' at line 36

Related articles
  • MySQL Old Dump Files 2014-10-14

    I've inheritied a mysql dump from a 3.23 database. The appliance I'm supposed to reload it on is a 4.1 mysql database. it's bombing out on me, which really doesn't surprise me. However, I'm wondering if there is a script out there that will go throug

  • MySQL big dump files 2013-04-23

    Hi, I just joined this project and the main developer tells me that the db.sql is the dump file. Now the file is 350MB more or less and I never dealt with such big db files. I use phpMyadmin and it does not import those large files. I tried google an

  • Dump file from mysql 3 to mysql 5 2014-03-18

    So I have several databases that are running on a mysql 3 . and I am reinstalling my operating system etc and hopefully going with mysql 5. However I wanted to make sure before i upgraded the mysql 4 that comes with CentOS_4 that the dump file will w

  • MySQL ERROR 1045 (28000): Access denied while Loading Dump File (Probaly Bug) 2012-10-18

    i have lost this morning with a small trouble that makes me think its a bug on mysql. since i ve always used this line on my program this its a line generated by him so its not folder variable issues or file location. the database has exactly the sam

  • MySQL dump file 2012-01-14

    i have a dump file known as filexyz.sql, which is a copy of a database. how can i use this in mySql? as in i would want to insert all the database and the tables it consists of in mysql. how can i do that?

  • MySQL Problem in Restore metadata from Dump file . 2012-03-01

    I have problem with my dump file when i try to restore from dump file getting error . The problem start from here when one of my co worker took backup dump file and remove all database scheme from RDBMS due to update the web application ,He thought h

  • MySQL slave crashes when uploading a Dump-File 2012-05-07

    I have a master to master replication between host A and host B and a master to slave replication from host A to host C. When I try to upload a dump file of an Mysql Database on host A, it works on host A and Host B, but the Slave on host C crashes w

  • Transfering MySQL dump file ON hosting server 2012-09-17

    I have changed hosting companies. I have a database table with almost 100,000 records. It's about 11 MB in size. With the new hosting company I.... 1) do not have Shell access to run MySQL dump, and 2) I do not have FTP access to the database folder.

  • Cannot create mysql.db Restoring all databases from a dump file 2012-11-02

    I'm trying to restore all my databases from a dump file. I'm running MySQL Ver 14.14 Distrib 5.1.31, for unknown-linux-gnu (x86_64) using readline 5.1 [[email protected] databaseBackup]# mysql -u tupo_admin -p < backup-20100330-040205.sql Enter password: E

  • MySQL How to load database from a dump file 2012-11-10

    I used to write scripts for MySQL a few years ago but have not used it recently. Yesterday we received a dump file of our database from a third party software company and my manager asked me to restore it. I have downloaded and installed MySQL 5.0.51

  • PHP mysqli and restoring a dump file 2013-03-16

    I have a script that I use to insert/update/query my databases. It uses mysqli. I chose mysqli because my understanding was that the mysql client is depracating soon and so I thought I should figure out PDO or mysqli. I chose PDO and set to doing som

  • Querying mysql dump files 2013-03-27

    I have a dump of the mysql database with many normalized tables.Now I want to create different file containing the details of each entry from all the tables. Is it possible to do it with help of dump files(please tell me the fastest method). or only

  • MySQL Error 1049. Problem with a database restore from a dump file 2013-05-18

    I need your help. I installed MYSQL version: 5.0.24a-standard using the tarred file for Solaris 10 and the configuration was completed correctly. The mysql server is running fine on my older AMD 1GHz x86 motherboard. I want to restore the dump file I

  • MySQL Export data from Oracle dump files directly 2013-07-06

    Oracle dump file (.DMP) is a binary storage used by Oracle users and database administrators to backup data. Oracle distribution pack includes the standard tools EXP or EXPDP for this purpose. The problem is that Oracle dump file is a "black box" and

  • MySQL Slow import of dump file 2013-07-30

    I am trying to "seed" my database with a large dump file. The dump file is constructed by me to look like one created by mysqldump.exe, and it is about 2Gb in size. When I try to import it I can see that mysql.exe reads about 60Kb a second, which sou

  • Importing huge dump files into mysql 2013-08-04

    I'm new to MySQL, so please bear with me if you find this query redundant or frivolous.. :( I'm trying to import a .sql dump file (approx 22G in size) into mysql.. Its been 62hrs now and the import is still not complete.. In the first few hours mysql

  • Creating a mySQL dump file 2013-11-08

    I have over 15,000 records within a local mySQL table. I need to create a dump file so that I may insert these into a mySQL table on a web server. Does anyone know the code to product a dump file?

  • ERROR 2013 (HY000) while importing large mysql dump file 2014-02-05

    I'm trying to import these sql dump files. There are a bunch of them, all multiple gigs. Most are around 3-5gigs, one is 69gigs. Well it gives me this error after a very short while: ERROR 2013 (HY000) at line 103: Lost connection to MySQL server dur

  • Convert MySQL dump file to Access? 2014-03-27

    Is there a way to convert a MySQL dump file to MS Access? I don't have access to the MySQL server, just the dump file.

  • Very slow restoring of MySQL dump file 2014-07-23

    I have mysql dump file with "13GB" of size given by our client. I tried to restore it in my mysql database with version 5.1.26. I started restoring this dump using the command 'mysql -uroot db_name < resore_file.sql'. As the size is large, I made