Hi,
I recently migrated my account from one ISP to another and I have experienced a number of MySQL-related issues.
I exported from ISP-A using phpMyAdmin and imported using phpMyAdmin on ISP-B.
When I tried to import the export file, I was unable to because MySQL would hiccup on all lines that looked like this:
CREATE TABLE IF NOT EXISTS `sequences` (
`name` varchar(255) NOT NULL default '',
`id` int(10) unsigned NOT NULL default '0', <--- Error
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
It balked on the number 0 between single quotes.
I ended up cutting and pasting all of the information in the phpMyAdmin SQL query page.
Then, I looked at the data as displayed by my site, and everything that had single quotes, became doubled. So something like this:
This ain't right
became like this:
This ain''t right
I logged a bug with my ISP but I really don't understand what the problem is. If anyone has better knowledge of MySQL (4.1.20) than i do and can explain what is going on, I would greatly appreciate it.
Thanks,
L
