Hi,
A database is being moved to another server and I'm trying to run the scripts created with the db dump via the "run sql queries" using the text file.
However, whenever I do so - or just try to use the form to run any query _ get an error like:
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬
Database parlour
Error
SQL-query:
ntent-Transfer-Encoding: binary
phpMyAdmin MySQL-Dump
#
Host: localhost Database : parlour
--------------------------------------------------------
#
Table structure for table \'Areas\'
#
CREATE TABLE Areas (
id smallint(6) NOT NULL auto_increment,
Area text NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id),
KEY id_2 (id)
);
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬
Note the "ntent-Transfer-Encoding: binary" being inserted at the top.
Anyone have any idea how to work around this? it looks like a problem with the web server...
Is there a simple script to execute a SQL file that has been uploaded to the servers ftp space? - basically restoreing a db dump via PHP - I could use this to at least get the db running?
Cheers,
Steve
