Still trying to move host

[riker]

Yes still trying to move but no matter where I try my backups keep messing up.  For some reason the charactors are playing up like £ going to ?

Now I've tried backups from phpmyadmin and smf but nothing seems to change

Does anyone know how I can pull a fully working backup from my existing host?

[riker]

I'm now getting

Error     SQL query:                   -- ==========================================================
--
-- Database dump of tables in `a5543780_tv`
-- October 30, 2008, 11:45:43 AM
--
-- ==========================================================
--
-- Table structure for table `smf_admin_info_files`
--
DROP  TABLE  IF  EXISTS  `smf_admin_info_files` ;

Tried backup from smf and phpmyadmin. Backups are from -
MySQL - 5.0.27 & trying to be uploaded too MySQL client version: 5.0.32

[babjusi]

I'm now getting

Error     SQL query:                   -- ==========================================================
--
-- Database dump of tables in `a5543780_tv`
-- October 30, 2008, 11:45:43 AM
--
-- ==========================================================
--
-- Table structure for table `smf_admin_info_files`
--
DROP  TABLE  IF  EXISTS  `smf_admin_info_files` ;

Tried backup from smf and phpmyadmin. Backups are from -
MySQL - 5.0.27 & trying to be uploaded too MySQL client version: 5.0.32

Is that all the error that you are getting cause that doesn''t tell us much.

How to backup/restore your db, have a look at the very last link in my signature.

[riker]

I'm now getting

Error     SQL query:                   -- ==========================================================
--
-- Database dump of tables in `a5543780_tv`
-- October 30, 2008, 11:45:43 AM
--
-- ==========================================================
--
-- Table structure for table `smf_admin_info_files`
--
DROP  TABLE  IF  EXISTS  `smf_admin_info_files` ;

Tried backup from smf and phpmyadmin. Backups are from -
MySQL - 5.0.27 & trying to be uploaded too MySQL client version: 5.0.32

Is that all the error that you are getting cause that doesn''t tell us much.

How to backup/restore your db, have a look at the very last link in my signature.

I've uninstalled the ad mod and now got a backup but some charactors still mess up on transfer to a new host.  Now I have checked the backup and the contents do seem okay until moved. Example

"criticised for £500,000" will be "criticised for ?500,000"

[jossanaijr]

Are you using UTF-8?

[riker]

Are you using UTF-8?

That's the default when trying to import but I've also tried ascii.


EDIT:  Binary works

[Nathaniel]

So have you now successfully made the move? Or do you still need help?

[riker]

So have you now successfully made the move? Or do you still need help?

No I've done it now thanks and found that "Auto Embed Video/Audio Clips" works on this new host but caused problems on the old one, yea strange