FreeHostia Forums
http://forum.freehostia.com/

Transfering DB to freehostia fails
http://forum.freehostia.com/viewtopic.php?f=7&t=7861
Page 1 of 1

Author:  pcforce [ Sun Aug 19, 2007 2:29 pm ]
Post subject:  Transfering DB to freehostia fails

Because i moved my website to freehostia :) went moving the mysql database here aswell. Problem is that evry time i try to execute gz or bzip copy of my db in phpmyadmin it ends in "Browser cannot display this page" and my db stays empty.

Author:  FnCool [ Sun Aug 19, 2007 3:59 pm ]
Post subject: 

i've had the same problem many times, i think it's due to freehostia using a different version of phpmyadmin than my other host.

check the file you are trying to import for a line like this:
ENGINE=MyISAM DEFAULT CHARSET=latin1;
it's the last line of every CREATE TABLE command

replace all those lines with:
TYPE=MyISAM;

if it still fails, try manually entering them (copy and paste into the sql query)

here's an example of one query that doesn't work:

--
-- Table structure for table `Help`
--

DROP TABLE IF EXISTS `Help`;
CREATE TABLE `Help` (
`Number` int(11) NOT NULL auto_increment,
`Body` text,
PRIMARY KEY (`Number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `Help`
--


-- --------------------------------------------------------

and here's one that does work:


#
# Table structure for table `Help`
#

CREATE TABLE Help (
Number int(11) NOT NULL auto_increment,
Body text,
PRIMARY KEY (Number)
) TYPE=MyISAM;
# --------------------------------------------------------


if you are still having problems, do what i did to figure it out in the first place... manually create a table in phpmyadmin, then export it, open it and compare it to your existing, then modify accordingly.

phpmyadmin is not always backward (or forward) compatible, so this is something good for everyone to know, no matter who is hosting your site.


i'd also recommend you export all your files as .sql instead of .gz or .bzip, i've had problems with this in the past (on other sites) aswell.

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/