> In transferring a data base from bluehost to a local hard drive with msql
> and phpMyadmin 2.9 I get import errors to the local database.. After each
> table there is
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1; This gives a parse error Have to
> change to TYPE=MyISAM
> and delete the default statement. If there is an autoincrement statement
> have to delete it also..
> Then it will import with no errors.
> Also in the local phpmyadmin when logging on I get these 2 errors
> Your configuration file contains settings (root with no password) that
> correspond to the default MySQL privileged account.
> Your MySQL server is running with this default, is open to intrusion, and
> you really should fix this security hole.
> The mbstring PHP extension was not found and you seem to be using a
> multibyte charset. Without the mbstring extension phpMyAdmin is unable to
> split strings correctly and it may result in unexpected results.
> Does this have anything to do with it?
collations are only supported as of mysql 4.1 ,
you have use "SQL compatibility mode MYSQL40" on the export page.
the errors are only warnings ;)
View this message in context: http://www.nabble.com/phpMyAdmin-Errors-tf3396394.html#a9463696
Sent from the phpmyadmin-users mailing list archive at Nabble.com.