cabbie
03-12-2007, 11:00 AM
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?
) 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?