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/
|
