Welcome to WebmasterWorld Guest from 34.231.247.139

Forum Moderators: open

Message Too Old, No Replies

Migrating data from MySQL 3 to 4

     
8:30 am on Nov 14, 2006 (gmt 0)

New User

10+ Year Member

joined:Dec 7, 2004
posts:9
votes: 0


Hi, I am trying to transfer my database from my old server running MySQL 3.23.58 to a new server running MySQL 4.1.20.

I did a mysqldump and transfered the dump file to the new server. When i tried to import the dump file back using mysqldump, I received this error message:

-- Host: localhost Database: databasename
-- ------------------------------------------------------
-- Server version 4.1.20

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

===================================================================

Any way to overcome this problem? What am i doing wrong? Thanks.

12:08 pm on Nov 14, 2006 (gmt 0)

New User

10+ Year Member

joined:Feb 2, 2005
posts:34
votes: 0


Hi,

you have to use mysql client program to import dump, not the mysqldump utility.

Try: mysql database_name < dump_file.sql

3:04 am on Nov 15, 2006 (gmt 0)

New User

10+ Year Member

joined:Dec 7, 2004
posts:9
votes: 0


Thank you for the quick response! It works now ;)
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members