Problems importing/exporting MySQL Database

dookie

Hi, i made a little system using php and mysql. To have web access, i have a domain and a hosting plan.
When i was programming, i used my pc, as localhost using PHP5 and MySQL 4. The hosting have PHP5 and MySQL4 too.

When i created a .sql script to create the db on the hosting (i used "EMS SQL Manager 2005 for MySQL") i imported it using phpmyadmin on the hosting and the db was created but i have som characters issues, with letters like ñ and á é í ó ú. I just fixed those details manually using the hosting's phpmyadmin.
So now i have the DB in the hosting with all the data ok.

I want to can create backups of that DB to save them here in my pc, just manually. So to test, i entered to the hosting phpmyadmin and y exported the DB to a .sql script. Just to test if thas would work, i created another db on the hosting to import the script previously generated.
The problem with this new DB is that again, i have that characters issue. For default is imported as utf8.

If i import the database selecting "latin1" (the script was save automatically with taht format) the data is ok, but i cant connect to de DB and i obtain this error:

So what can i do, i found very strange that if i already have a working db on the hosting, with good characters and i export/import using just the hosting tool, and importing it to the same hosting i have this problems.

Any help?

WDPEjoe

What's the code you're using to connect to the database? That error means that the connection variable itself (whatever you assigned mysqli_connect() to) is invalid. Check that your host, username, and password are correct.

dookie

This is the code im using:

<?
$dbhost="localhost";
$dbusuario="root";
$dbpassword="xxxx";
$db="sgc";
$conexion = mysql_connect($dbhost, $dbusuario, $dbpassword);
mysql_select_db($db, $conexion);
?>

and when i use it with the db that is already in the host, works fine

WDPEjoe

ok, let me know what error you get when you run this:

$dbhost="localhost";
$dbusuario="root";
$dbpassword="xxxx";
$db="sgc";
$conexion = mysql_connect($dbhost, $dbusuario, $dbpassword) or die(mysql_error());
mysql_select_db($db, $conexion);