It is currently Fri Mar 29, 2024 7:02 am


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Transfering DB to freehostia fails
PostPosted: Sun Aug 19, 2007 2:29 pm 
Newbie
Newbie

Joined: Thu Aug 16, 2007 11:49 am
Posts: 3
Location: Sofia, Bulgaria
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.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Aug 19, 2007 3:59 pm 
Regular
Regular

Joined: Sun Apr 15, 2007 5:14 pm
Posts: 308
Location: Barrie On Ca
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ]  Moderators: Moderators, Support Team

All times are UTC


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Hosting | Domains | Servers | Extras | Order | Support | Contacts | FreeHostia © 2011