Export, Import issue...

[danthemilk]

I am exporting my mySQL 5.0.41, UTF-8 database using the phpMyAdmin dialog on my localhost with these settings:

type: SQL

compatibility mode: NONE

save as file: checked

compression: NONE

 

Then, I'm importing the file to a mySQL 5.0.45, UTF-8 database using phpMyAdmin on a remote server with the following settings:

compatibility mode: NONE

allow interrupt: checked

 

The database appears to import without any problems. I can browse the tables with phpMyAdmin on the remote server, and edit them etc using the client. However, when I query the database with php I get an invalid resource. When I query the database for tables that existed prior to importing the new tables, I get a valid result. Does anybody know why I might be getting an invalid resource when my query result is a newly imported table?

 

 

[rhodesa]

what is the error from mysql_error()?

[danthemilk]

mysql_error($result) returns:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

[danthemilk]

my query looks like this:

 

$result = mysql_query("SELECT * FROM `newly_imported_table`");

[rhodesa]

change it to:

$result = mysql_query("SELECT * FROM `newly_imported_table`") or die(mysql_error());

[danthemilk]

it says

 

Table 'database.newly_added_table' doesn't exist

 

It clearly does exist, but that's a helpful hint. Thanks for your help so far! Any ideas why it wouldn't find the table?

[rhodesa]

this is a mysql database? make sure the user has the proper rights to access the table and you are connecting to the correct database