FRIHOSTFORUMSSEARCHFAQTOSBLOGSCOMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Using my local SQL dump on frihost





woodenbrick
Ok, so when I do an SQL dump of all my tables on my localhost, I end up with lines like this:
Code:

CREATE TABLE `archivefat` (
`id` int( 4 ) NOT NULL ,
`name` varchar( 30 ) COLLATE latin1_general_ciNOT NULL ,
`high` int( 4 ) NOT NULL ,
`low` int( 4 ) NOT NULL ,
`opponent` varchar( 30 ) COLLATE latin1_general_ci NOT NULL ,
`avg` int( 4 ) NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci;

When I try to import it in frihost it doesn't allow, because of the COLLATE and DEFAULT CHARSET lines. Is there something I can do, either on my localhost or frihost, That wont require me to go through manually and delete all these lines?
kv
Remove the lines "DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci" (do a find and replace it with blank). Then try importing into frihost. It should go through without any problem.

take care not to remove semicolon after latin1_general_ci.
Related topics
Problem with my SQL Server (not Frihost)
cant build site using flash (swf) on frihost
making sql dump wit php
Using mail() func on Frihost
Trying to move SQL database
Help teach me a simple online application using this Frihost
Problems with SQL and Frihost...
SLOW UPLOADING AN SQL FILE
[help] como mudar una BD?
how to transfer data from one host to another?
Sql/Phpbb error...
Blogger on Frihost
Petit problème d'import de base MySQL
Using smarty here at FriHost.
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.