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. Q and A 
  4.  / How to copy a large database?
Register
1
luciano
How to copy a large database?

  • 2005/12/15 13:23

  • luciano

  • Quite a regular

  • Posts: 261

  • Since: 2003/11/3


When one of my sites needed moving I bumped into the import limit of PHPMyAdmin. The problem seemed to be the private messages, so I just didn't copy them and then runned the export again with only the private messages: problem solved.

But what happens when you have tables that are too big... in that case splitting could be a lot of work. I didn't try I but I found this: http://www.ozerov.de/bigdump.php
2
McDonald
Re: How to copy a large database?

  • 2005/12/15 13:45

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


For importing a large database file, like the iptoc database of XM-Memberstats, I normally use BigDump too.

Another option is the module XOOPS DB Backup & Restore 3.0. BigDump has been integrated in this module.
XOOPS DB Backup & Restore 3.0 has different backup options. You can backup your database tables to a folder on your server, but also have each table sent by email (not handy with big tables I think).
Each table can be restored separately.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

411 user(s) are online (308 user(s) are browsing Support Forums)

Members: 0

Guests: 411

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