XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / Xoops Tip: Importing large MYSQL files with BigDump
Register
1
jeffgr
Xoops Tip: Importing large MYSQL files with BigDump

  • 2007/10/22 14:08

  • jeffgr

  • Quite a regular

  • Posts: 263

  • Since: 2004/2/22


Hi everyone,

I just wrote a short blog post about importing large MySQL database files with a script called BigDump, which imports your database file in small increments, getting around the "server timeout issue". If you have to backup and import large XOOPS database MySQL files, this might be a good tip for you.

Restoring your XOOPS database with BigDump

Cheers,

jeffgr

XoopsExperts.com
2
McDonald
Re: Xoops Tip: Importing large MYSQL files with BigDump

  • 2007/10/22 15:17

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


Some database backup & restore modules like BackPack and Xoops DB Backup & Restore (see repository) have BigDump integrated.

Another good database script is MySQLDumper.
3
svaha
Re: Xoops Tip: Importing large MYSQL files with BigDump

  • 2007/10/22 15:24

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Thanks for this Jeff, I myself have been using mysqldumper for quite some time now, very good imho.

Mysqldumper can also break a large database into small parts, that is sometimes necessary because some hosts allow for instance only 10.000 inserts in one hour.
So even if you have a restore program that takes a break now and then, you will get to this limit (of 10.000 inserts) very soon and then the party is over.
4
Peekay
Re: Xoops Tip: Importing large MYSQL files with BigDump

  • 2007/10/22 15:40

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


BigDump gets my vote Some shared hosts are really mean with their SQL upload limits. This utility has saved the day for me more than once.
A thread is for life. Not just for Christmas.
5
svaha
Re: Xoops Tip: Importing large MYSQL files with BigDump

  • 2007/10/22 16:25

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Quote:

Peekay wrote:
BigDump gets my vote Some shared hosts are really mean with their SQL upload limits. This utility has saved the day for me more than once.


Can bigdump deal with for instance 120.000 inserts when there is a limit set by the host of 10.000 / hour?

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

328 user(s) are online (254 user(s) are browsing Support Forums)

Members: 0

Guests: 328

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits