22 Feb 2007 at 17:34 #1 iBot iBot Permabanned Joined 12 Sep 2005 Posts 3,303 Location England Hi guys, i have a database dumped from mysql 5.x I need to import it in to a server running 4.x Ive been told i cant because of the collate keyword. Is there anyway to overcome this?
Hi guys, i have a database dumped from mysql 5.x I need to import it in to a server running 4.x Ive been told i cant because of the collate keyword. Is there anyway to overcome this?
22 Feb 2007 at 19:17 #2 Clarkey Clarkey Soldato Joined 18 Oct 2002 Posts 18,306 easy way around this is to use phpmyadmin to export the database and use the SQL compatability mode.
22 Feb 2007 at 19:26 #3 iBot iBot Permabanned OP Joined 12 Sep 2005 Posts 3,303 Location England How do i do that?
22 Feb 2007 at 19:43 #4 lookitsjonno lookitsjonno Soldato Joined 10 Sep 2003 Posts 5,019 Location Midlands or if it's a large file, upload and email your host who will import it with one command
22 Feb 2007 at 19:49 #5 iBot iBot Permabanned OP Joined 12 Sep 2005 Posts 3,303 Location England jonno.co.uk said: or if it's a large file, upload and email your host who will import it with one command Click to expand... It's only a 10mb database and I already tried that. They told me it was Incompatible as they are running mysql 4x
jonno.co.uk said: or if it's a large file, upload and email your host who will import it with one command Click to expand... It's only a 10mb database and I already tried that. They told me it was Incompatible as they are running mysql 4x
23 Feb 2007 at 18:17 #6 iBot iBot Permabanned OP Joined 12 Sep 2005 Posts 3,303 Location England anyone?
