Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro
Author Message
justcdr
Hangin' Around


Joined: Mar 08, 2005
Posts: 48

PostPosted: Wed Aug 09, 2006 4:55 pm Reply with quote

had to change my webhost, i dropped the tables on the new database, went to import database.

On the database sql file i changed the database name to the new one now.

but get this error message after it tries to upload it

Ive tried uploading in zip and gz format but same message.

The actual database file after extracting is just a file format, no extenstions on it.


Error
SQL query:

-- MySQL dump 10.9
--
-- Host: localhost Database: staukcla_sta
-- ------------------------------------------------------
-- Server version 4.1.19-standard
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;



MySQL said:

#1065 - Query was empty
 
View user's profile Send private message
gregexp
The Mouse Is Extension Of Arm


Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Wed Aug 09, 2006 6:12 pm Reply with quote

How did you get the backup you made?

_________________
For those who stand shall NEVER fall and those who fall shall RISE once more!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
justcdr
PostPosted: Wed Aug 09, 2006 6:14 pm Reply with quote

the backup was done by cpanel on my last host .gz format

the new host uses vdeck, ive tried uploading the database using myphp but get the message above.

i also tried uploading the file using vdeck database restore, in zip, tar.gz and gz none will work.
 
justcdr
PostPosted: Wed Aug 09, 2006 6:23 pm Reply with quote

just to test i the vdeck backup, i backed up the normal ravennuke install and it does a single .tar file, but when you extract it, the backup has a single file for each table etc..

so the restore isnt going to work via vdeck, is there any way to restore it via myphp
 
gregexp
PostPosted: Wed Aug 09, 2006 6:26 pm Reply with quote

Perhaps, Can you back it up via the export option in phpmyadmin?
 
justcdr
PostPosted: Wed Aug 09, 2006 6:51 pm Reply with quote

looks like the problem is with perl version installed, on my old host they had a newer version than my new 1 Sad
 
gregexp
PostPosted: Wed Aug 09, 2006 9:17 pm Reply with quote

For the most part, phpmyadmin will use a simple format which is readable by most others. If possible, Export JUST the database from phpmyadmin, Then try to use that as the backup instead of the server backup function, This is common in my experience that the cpanel backup doesnt operate correctly.
 
justcdr
PostPosted: Thu Aug 10, 2006 4:38 am Reply with quote

on the old webhost were im transfering from it has this junk of code were in the new sql it just has a row of lines, nearly after every table


/*!40000 ALTER TABLE `nuke_bbtopics_watch` DISABLE KEYS */;
LOCK TABLES `nuke_bbtopics_watch` WRITE;
INSERT INTO `nuke_bbtopics_watch` (`topic_id`, `user_id`, `notify_status`) VALUES (4,2,1),(7,2,0),(5,2,0),(6,2,1),(12,2,0),(17,2,0),(19,2,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `nuke_bbtopics_watch` ENABLE KEYS */;
 
gregexp
PostPosted: Thu Aug 10, 2006 7:01 pm Reply with quote

I have NEVER seen anything like that, Perhaps others here have and would be better suited to give advice on what to do, As for mine would be to delete the excess but Im not familiar with this and would only advice that you test that idea.

I dont have the time to wrap my head around this right now. Id like to but work and server have me tide up currently.
 
justcdr
PostPosted: Fri Aug 11, 2006 12:12 am Reply with quote

tried changing the bits but still give me errors, have just started from scratch now again Sad

for future backups, see the backup feature inside admin, what does that exactly restore ? will that restore all forum posts and admin, users etc.. ?
 
gregexp
PostPosted: Fri Aug 11, 2006 7:10 pm Reply with quote

yes and no. In my experience that is not the best way but small sites may have a chance.

It seems to add html in some parts and giberish in others.
 
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Sat Aug 12, 2006 3:25 am Reply with quote

@ justcdr , i dont promise anything but i can see if its possible to restore it,but i need a copy of the backup you have.,..
you can pm me for that...

btw..cpanel backups usualy works flawless..
i use it often and always grab my whole stuff packed in about 845 mb file.
and in perfect shape..
but it depends on the host i guess..
 
View user's profile Send private message
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.00.00 - v2.02.00 Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©