Gentoo Forums :: View topic - Getting ERROR 1114 while restoring mysql DB from a dump

Getting ERROR 1114 while restoring mysql DB from a dump

View unanswered posts
View posts from last 24 hours

Gentoo Forums Forum Index

Other Things Gentoo

View previous topic :: View next topic

Author

Message

biggyL
Tux's lil' helper

Tux's lil' helper

Joined: 31 Jan 2005
Posts: 120
Location: Israel

Posted: Tue Jan 15, 2008 6:19 am Post subject: Getting ERROR 1114 while restoring mysql DB from a dump

Reply with quote

Hello All,

I'm trying to transfer all my mysql DB's (15 mediawiki DB's) from the old server to the new one.
"mysql Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686) using readline 5.0"->"mysql Ver 14.12 Distrib 5.0.44, for pc-linux-gnu (i686) using readline 5.2"

Now, on the old server I did a dump:

Code:

# /usr/bin/mysqldump -u root -p --opt --all-databases > /home/lkolchin/alldbnew.sql

And on the new one:

Code:

# cat /home/lkolchin/alldbnew.sql | mysql -u root -p
Enter password:
ERROR 1114 (HY000) at line 11192: The table 'mw1_text' is full

As you can see I got ERROR 1114

How can I solve this problem?
Any help please?

Send private message

biggyL
Tux's lil' helper

Tux's lil' helper

Joined: 31 Jan 2005
Posts: 120
Location: Israel

Posted: Tue Jan 15, 2008 12:59 pm Post subject:

Reply with quote

OK,

adding this

Code:

innodb_data_file_path = ibdata1:1900M;ibdata2:100M:autoextend:max:1900M

to my.cnf would solve the issue

preferences: http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html

Send private message

Display posts from previous:

	Gentoo Forums Forum Index Other Things Gentoo	All times are GMT
Page 1 of 1

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Copyright 2001-2024 Gentoo Foundation, Inc. Designed by Kyle Manna © 2003; Style derived from original subSilver theme. | Hosting by Gossamer Threads Inc. © | Powered by phpBB 2.0.23-gentoo-p11 © 2001, 2002 phpBB Group
Privacy Policy