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.  / Problem with restore database.
Register
1
svaha
Problem with restore database.

  • 2004/1/30 12:49

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Hi, I've a problem with updating my local database (never before)
I make a backup/dump of my site with MySQL 4.0.15 that's saved on my own computer. Then I empty my local database (mysql 4.0.16) and then restore by selecting the saved dumpfile.
This went always right, but now the local MySQL gives a message : Not a sql file.

Has anyone an idea?

Aloha
2
svaha
Re: Problem with restore database.

  • 2004/1/30 19:00

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


ZOEM ZOEM ZOEM ZOEM [size=xx-small]bump[/size]
3
m0nty
Re: Problem with restore database.

  • 2004/1/30 21:25

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


did u dump it as a cvs file or xml??

u need to dump it just as structure and data, also is an idea to use drop tables aswell..

in phpmyadmin this is done easily with tick boxex blah blah blah..

just save it as a text file (uncompressed)

if it saves it as .txt then then u just have to rename it to .sql (this will only work for txt files tho renaming a CVS or XML format will not work!!)
4
svaha
Re: Problem with restore database.

  • 2004/1/30 22:12

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


I used export option, selected all the tables, choose to dump it as txt with extension sql
structure and data
With structure I have also the options : Add AUTO_INCREMENT value and : Enclose table and field names with backquotes
I will try also with the drop tables option.

Strange (to me) is that it worked all the time, and now it doesn't, I've compared the .sql files that work and don't work but can't see a difference.
(Could the size be a problem on my local system?) Now the size is > 2 Mb.

I tried also earlyer gzipped files, but that never worked on my local site

Ps : Thnx for your answer

Aloha
5
djsckizo
Re: Problem with restore database.

  • 2004/1/30 22:25

  • djsckizo

  • Just can't stay away

  • Posts: 401

  • Since: 2003/5/9 8


Well you could always do it the long way around if you had to and sql parts of it until you finally get it all in there.
6
svaha
Re: Problem with restore database.

  • 2004/1/30 22:47

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Thanks djsckizo, I just tried that one a few minutes ago and it WORKED ! Man, am I glad. I cut the 2Mb .sql file in three pieces.
Don't know where there is a restriction, in MySQL or in the win2000 system, but it was sure a misleading error message that I got from Mysql.
Anyway thanks for your replies, problem solved
7
Dave_L
Re: Problem with restore database.

  • 2004/1/31 1:09

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


One possibility is that there are a couple of PHP configuration parameters that limit the size of file uploads: post_max_size and upload_max_filesize.
8
svaha
Re: Problem with restore database.

  • 2004/2/1 8:56

  • svaha

  • Just can't stay away

  • Posts: 896

  • Since: 2003/8/2 2


Ok, thanks Dave, I'll look into that.
I also read about a problem Nuker had with attaching files (big files) to WF-section articles (though he had filesize set to Much bigger then the actual filesize) Could this also be a host/php related setting that you can't change as a user?

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

134 user(s) are online (63 user(s) are browsing Support Forums)

Members: 0

Guests: 134

more...

Donat-O-Meter

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

Latest GitHub Commits