[Forum] SQL issue

[The Republican]

I'm running vB 4.1.12. The hard drive that the SQL database was running on had a failure and we had to switch to another drive. We were able to mount the old hard drive to the system. I copied the vB database over to the new drive in the same exact path, however, I get this error when attempting to access:

#1017 - Can't find file: './directory/aaggregate_temp_1341591000.frm' (errno: 13)

I get that error for every table. I know this probably should be in an SQL support forum somewhere, but I figured someone here has enough SQL experience to help with this.

[kh99]

errno 13 is a permission error. I'm don't know a lot about MySQL admin, but maybe check the owner/permissions on the new files and make sure they match the old ones.

[Dustin L.]

If you're on CentOS, are you running SELinux?

[The Republican]

If you're on CentOS, are you running SELinux?

Nope, Debian 6.

[Dustin L.]

Well, it is a permissions issue. Do you have access to SFTP/SSH?



Dustin

[The Republican]

Well, it is a permissions issue. Do you have access to SFTP/SSH?



Dustin

Yep. I have access to everything.

[Dustin L.]

Okay. As always, make a backup of your entire database before doing this.

You'll need to log-in to MySQL from the command line, and then we're going to create a new user with permissions using the command below. This will also be the user you should put into the vBulletin configuration file.

grant all privileges on yourdatabase.* to yourdesireduser@"localhost" identified by 'yourpassword';

Replace yourdatabase with the name of your database, replace yourdesireduser with the desired name of a new MySQL user, if needed, replace localhost with the address to your MySQL server, and replace yourpassword with the password you desire the new MySQL user to have.

See if that does it.



Dustin

[The Republican]

Okay. As always, make a backup of your entire database before doing this.

You'll need to log-in to MySQL from the command line, and then we're going to create a new user with permissions using the command below. This will also be the user you should put into the vBulletin configuration file.

grant all privileges on yourdatabase.* to yourdesireduser@"localhost" identified by 'yourpassword';

Replace yourdatabase with the name of your database, replace yourdesireduser with the desired name of a new MySQL user, if needed, replace localhost with the address to your MySQL server, and replace yourpassword with the password you desire the new MySQL user to have.

See if that does it.



Dustin

Gave that a try.. still the same error.

[Dustin L.]

Hmm, that's odd.

This is going to sound stupid, but have you tried restarting the MySQL daemon?

You can do so via SSH:

/etc/init.d/mysqld restart

Dustin

[kh99]

I think granting permissions didn't work because the problem isn't mysql permissions, it's OS file permissions. i.e, whatever user/group the mysql server process is running as doesn't have the necessary permissions on the files/directory structure that were created on the new drive.