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:
?br />
Database parlour
Error
SQL-query:
ntent-Transfer-Encoding: binary
# phpMyAdmin MySQL-Dump
# <!-- m --><a class="postlink" href="http://phpwizard.net/phpMyAdmin/">http://phpwizard.net/phpMyAdmin/</a><!-- m -->
#
# 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
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:
?br />
Database parlour
Error
SQL-query:
ntent-Transfer-Encoding: binary
# phpMyAdmin MySQL-Dump
# <!-- m --><a class="postlink" href="http://phpwizard.net/phpMyAdmin/">http://phpwizard.net/phpMyAdmin/</a><!-- m -->
#
# 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