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

Username:
Password:

Lost Password? Register now!

Who's Online

70 user(s) are online (46 user(s) are browsing Support Forums)


Members: 0


Guests: 70


more...

Donat-O-Meter

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

Latest GitHub Commits