error when trying to get database online (intermedia)

-

someone here recommended using intermedia coldfusion hosting, , i'm relatively happy them, can't offer support problem i"m having.  i'm trying mysql database online, error:

 

cannot restore database backup 'mymindsnotrighttest.sql' (error  occurred while evaling command (errstr = [error] [2010-08-17 13:16:24]  main::imedia::hp::mysql::

restoredatabasefrombackup: cannot restore database backup 'mymindsnotrighttest.sql' ([error]  imedia::hp::mysql::imedia::admin::backupmanager::mysql::restore: cannot restore backup database via command 'cat /mnt/smb/backup/mysql/mikewycklendt/mymindsnotrighttest/mymindsnotrighttest.sql | mysql --user=mysql_svc --database=mymindsnotrighttest'  (exitcode=1, error=, stderr=error 1064 (42000) @ line 102: have an  error in sql syntax; check manual corresponds your  mysql server version right syntax use near 'using btree )  engine=innodb default charset=latin1 row_format=compact' @ line 12 cat:  write error: broken pipe)),errcode = -1))

 

everything works fine when i'm using localhost.  support guy intermedia told me "reviewed sql file , not appear have problem"  don't know go here...

ok, went , made new database changed character set / collation... aside change, same, error saying datasource not found when can see tables in intermedia's phpmyadmin page... changing character set / collation cause error?



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

How to decompile jsxbin to jsx

-
hi all, i have jsxbin script. want edit script, need decompile script jsx. how can possible.     thanks in advance, mahesh it's not.   the whole idea behind jsxbin, protect being viewed , edited...   harbs More discussions in InDesign Scripting adobe
Read more

Gavik Photoslide GK2: Not able to upload photos - Joomla! Forum - community, help and support

-
my first slide show works. i upgraded joomla 1.5.14. created new slide show, no images shown. i checked firebug , found images should go http://mywebsite.com/components/com_gk2 ... es/thumbm/ directory. however images go /components/com_gk2_photoslide/images/ directory. catalog permission says followings. 1. images/ unwritable 2 images/thumbm/ unwritable 3 images/thumbs/ unwritable 4 configuration/ unwritable 5 configuration/plugins/ unwritable 6 configuration/extensions/ unwritable i checked chomd ftp , 755. could tell me how fix please? thanks in advance. you'll have better luck on developers website, bug component , there 2 or 3 different reasons. seem remember 1 thing make sure php extension enabled on server. fixed problem hacking php files months ago have assumed had fixed bug. dm Board index Joomla! Older Version Support Joomla! 1.5 Extensions for Joomla! 1.5 ...
Read more

Phoca Guestbook logger registret bruger af - Joomla! Forum - community, help and support

-
hej, problemet jeg har installeret phoca guestbook og det virker næsten. hvergang en registreret bruger har skrevet gæstebogen og trykker på send, så bliver brugeren logget af. så skal man logge på igen og kan konstatere @ indlægget er sendt og står pænt gæstebogen. hvordan forhindrer jeg joomla! og phoca guestbook @ smide brugeren af? lidt mere om opsætningen for @ skrive gæstebogen, så skal brugeren være registreret. derfor har jeg lavet et menupunkt, som kun kommer frem, når brugeren er registreret. og når man logger ind så åbner joomla! gæstebog-siden. jeg har indstillet gæstebog-siden til @ være registrerede brugere og menupunktet er sat op til de samme brugere. jeg håber @ nogle kan hjæpe. -- jan rou hej igen, og lige en detalje mere, der kan have betydning: .htaccess er aktiveret. -- jan rou Board index Joomla! International Language Support International Zone Danish Forum Ældre versioner (disse...
Read more