How To A 3.23 Mysql Dumpfile Into 4.0.25

[mikeyb]

I have several mysql databases that are MySQL 3.23.58 . I have them saved as dump files. I am trying to import them into a new MySQL 4.0.25-standard database, but the syntax structure is different. How can SQLyog help me import a raw .sql dump file created in 3.23.58 and successfully import it into a new 4.0.25 database?

Help.

[peterlaursen]

There should be no problems in importing a dump from MySQL 3.23 into 4.0!

I just created a database in MySQL 3.23 exported with SQLyog and got this

Code:

/*
SQLyog Enterprise – MySQL GUI v4.2 BETA 5
Host – 3.23.58-max-nt : Database – test
*********************************************************************
Server version : 3.23.58-max-nt
*/
create database if not exists `test`;
USE `test`;
/*Table structure for table `tablename1` */
DROP TABLE IF EXISTS `tablename1`;
CREATE TABLE `tablename1` (
 `id` bigint(20) NOT NULL auto_increment,
 `mynum` bigint(20) default NULL,
 `mytext` varchar(50) default NULL,
 PRIMARY KEY  (`id`)
) TYPE=MyISAM;
/*Data for the table `tablename1` */
insert into `tablename1` values (1,33,'thirtythree');
insert into `tablename1` values (2,44,'fortyfour');

It imports into MySQL 4.0 without any problems

What do you mean with a raw .sql dump file?

What program did you export with? If it was done with some php-script based tool from a forums system for instance it may not contain the necessary create and use statements. If that is it, try building the structure from SQLyog GUI first.

Also paste in the beginning of the file (no INSERTS are needed!) here so we can see what it is like!

[Ritesh]

There should be absolutely no problem importing a dump created from v3.23.x to v4.x.

I think there is a problem in the content of the dump file itself.

Can you attach the SQL dump file provided the data is not confidential? You can even mail them to [email protected].

[Baby]

I do ,too…So i want to know the way to backup data without phpadmin…

please help me..Thank you…

[Ritesh]

Connect to your MySQL server. Select the database in the object browser and use:

Db -> Export database as SQL dump

[Author]

Posts