Re: [Phpwiki-talk] Custom PhpWiki Backup failed

[Reini U. <ru...@x-...>]

Le Roux van Wyk schrieb:
> Thanx for the advice. I have installed phpMyAdmin, but it seems the sql file is corrupt or something. When I load it into the DB using the SQL tab, it gives me the following error:
> 
> Error
> 
> MySQL said:
> #1065 - Query was empty 

there must be a better error message, the line number where it failed.

> Yet if I look at the query, it does contain all the commands. 

give us the query which failed.
or do a simple backup/restore via PhpWikiAdministration (zip is fastest)

 > I've also tried to copy the contents and paste it into phpmyadmin, 
but > I get the same error. Am I missing something?

> 
> 
> -----Original Message-----
> From: Reini Urban [mailto:ru...@x-...]
> Sent: 13 July 2004 12:41
> To: Le Roux van Wyk
> Cc: Php...@li...
> Subject: Re: [Phpwiki-talk] Custom PhpWiki Backup failed
> 
> 
> Le Roux van Wyk schrieb:
> 
>>I have recently moved from Redhat to Debian and therefore had to
>>reinstall phpwiki. I didn't see the phpwiki backup facility, and just
>>exported the mysql tables to .sql and copied the entire phpwiki
>>directory over to the new machine. Now that I try to import the sql
>>files into the database, I get incomplete data. Will the phpwiki allow
>>this type of "copy"? Why is the data incomplete?
> 
> 
>>I used mysqlfront to export the data originally, and have never
>>before  had problems with data being incompletely exported.
>>Can anybody shed some light on the subject?
> 
> 
> probably errors with incorrect quoting or unsupported charsets.
> 
> please try phpmyadmin (for the stupid) or
> mysqldump and mysql (for the brave).
> 
> mysqldump --opt phpwiki > phpwiki.sql
> scp phpwiki.sql newmachine:
> ssh newmachine
> mysql phpwiki < phpwiki.sql
> 


-- 
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/