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. Beginner's Corner 
  4.  / cant import back up file for database
Register
1
heladope
cant import back up file for database

  • 2006/3/28 8:26

  • heladope

  • Just popping in

  • Posts: 15

  • Since: 2006/3/25


I had some server problems and had to dump my database, I created a back up and all files are still on server in the same locations, I just cant import the back up file into the database.

Can anyone help me with this?

I am using MySQL version 3.23.58 through webmin

I have named the file backupdb.db
2
m0nty
Re: cant import back up file for database

  • 2006/3/28 9:50

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


how did u back it up?

you could also try Bigdump
3
dizzymarkus
Re: cant import back up file for database

I know at first I was having problems , the more i messed with it the more I found a way lol


when you save the db make sure you name it exactly as the original name. EX "mydb_xoops" save the db as "mydb_xoops" or save it different but rename it before using it. Not sure if this is right or not but it works greatly for me as I do my work locally then upload it.

Hope this helps and isnt confusing,
Markus
4
Peekay
Re: cant import back up file for database

  • 2006/3/28 12:06

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


To elaborate on m0nty's excellent recommendation, PHPMyAdmin imposes limits on uploading/importing SQL files from your PC - a timeout (300 seconds) and a filesize (2 Mb, or sometimes less, depending on the host).

BigDump circumvents these limits. You simply FTP the SQL file to a folder on your web server along with the 'bigdump.php' script. Running the script via a web browser connects to your MySQL database and imports the file.
A thread is for life. Not just for Christmas.
5
Dave_L
Re: cant import back up file for database

  • 2006/3/28 13:31

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


phpMyAdmin, at least newer versions, can import/export to local files on the server, but you have to edit the config.inc.php file to enable that.

Bigdump might be better though in some cases. I haven't tried it.
6
McDonald
Re: cant import back up file for database

  • 2006/3/28 13:46

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


I use the module Xoops DB Backup & Restore 3.0 which has BigDump integrated. It lets you backup your database in one big file or in separate smaller files. You can restore the tables separately.
7
Peekay
Re: cant import back up file for database

  • 2006/3/28 14:22

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


@McDonald. Thx for that link.
A thread is for life. Not just for Christmas.
8
heladope
Re: cant import back up file for database

  • 2006/3/28 22:22

  • heladope

  • Just popping in

  • Posts: 15

  • Since: 2006/3/25


I changed the name of the file to "backup.sql" that worked

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

193 user(s) are online (121 user(s) are browsing Support Forums)

Members: 0

Guests: 193

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