Page 1 of 1

Mysql 4 database folders

Posted: Sat Nov 19, 2005 12:31 pm
by mhouldridge
Hi,

I have just installed mysql version 4 and have created my database and tables within navicat.

The database folder, named kp shows the users.frm and homes.frm but there is no myd myi files....

I cant do anthing on the site because i get the error,

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\Websites\KingstonProperty\user_registration2.php on line 351

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in E:\Websites\KingstonProperty\user_registration2.php on line 352
Can't open file: 'users.InnoDB'. (errno: 1)

Posted: Sat Nov 19, 2005 2:08 pm
by AKA Panama Jack
You will not have any myd or myi files if you are using INNODB tables instead of MYISAM tables.

InnoDB table data is stored in the ibdata files located in the mysql directory and not the directories named for the databases. And from that one error and the fact you only have frm files in the directories it looks like you may be using InnoDB databases.

After you connect to the data base you might want to add this line...

Code: Select all

echo mysql_error ();


...to see what error is returned when you try to connect. It doesn't look like you are connecting to the database. You may not have upgraded or installed EVERYTHING that was needed when you installed Mysql4.

Or you deleted the ibdata files or didn't copy them over if you moved the databases to a different directory or server.

Posted: Sat Nov 19, 2005 2:09 pm
by Charles256
also, echo out your SQL statment and run it through phpMyAdmin, it normally gives some pretty good error messages.