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.  / Restore database
Register
1
Roashan
Restore database

  • 2005/11/27 15:41

  • Roashan

  • Just popping in

  • Posts: 21

  • Since: 2003/9/28


Hallo everyone,

I have made a Backup of my MySQL database with MySQL Admin porgram. Now I have a textfile which is about 12MB. But I can't make a restore. Is there anyone know how to do it? It is really important, so please help me out.

Best regards:

HR
2
rabideau
Re: Restore database

  • 2005/11/27 16:18

  • rabideau

  • Home away from home

  • Posts: 1042

  • Since: 2003/4/25


If your text file has an extension of .sql you are halfway there.

Simply enter a tool like phpMyAdmin... and import the sql. Your restore should complete itself without incident, assuming your restore (backup) of the database was performed correctly.

Good luck!
Pax vobiscum,
...mark

may the road rise to meet your feet!

http://treemagic.org
3
Bender
Re: Restore database

  • 2005/11/27 17:06

  • Bender

  • Home away from home

  • Posts: 1899

  • Since: 2003/3/10


If it times out while restoring you will just have to split the file in parts and do them part by part.
Sorry, this signature is experiencing technical difficulties. We will return you to the sheduled signature as soon as possible ...
4
McDonald
Re: Restore database

  • 2005/11/27 17:16

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


If you have problems restoring big sql files into your database you should try BigDump: http://www.ozerov.de/bigdump.php

BigDump is also integrated in the module Xoops DB Backup & Restore 3.0.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

260 user(s) are online (207 user(s) are browsing Support Forums)

Members: 0

Guests: 260

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