errors running scripts via phpMyAdmin

admin

Administrator
Staff member
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
 
Back
Top