database [prefix_] possibly causing an issue?
database [prefix_] possibly causing an issue?
Hey Guys,
Decided to move over to VestaCP with my VPS, and all has gone good, up until this point.
So I was using ISPConfig3, and I was setting up a mySQL Database, I then imported my backup, and everything went well.
Long story short, I moved from ISPConfig3 over to VestaCP, and I tried to do the same, VestaCP puts the 'username' as the prefix, at first I was thinking, meh, no biggy, I'll go into the wp-config.php and change the details. It would appear that isn't just the case. (I don't fully know how SQL stores it's stuff, then database contents 'may' be referencing it's original database name?)
Is there a way to disable the [username] prefix on the database creation? Just so I can test my theory, as it might 'not' be that, but any troubleshooting contains a process of elimination, and this would be one of those 'processes'
Can anybody help me with this?
Decided to move over to VestaCP with my VPS, and all has gone good, up until this point.
So I was using ISPConfig3, and I was setting up a mySQL Database, I then imported my backup, and everything went well.
Long story short, I moved from ISPConfig3 over to VestaCP, and I tried to do the same, VestaCP puts the 'username' as the prefix, at first I was thinking, meh, no biggy, I'll go into the wp-config.php and change the details. It would appear that isn't just the case. (I don't fully know how SQL stores it's stuff, then database contents 'may' be referencing it's original database name?)
Is there a way to disable the [username] prefix on the database creation? Just so I can test my theory, as it might 'not' be that, but any troubleshooting contains a process of elimination, and this would be one of those 'processes'
Can anybody help me with this?
Re: database [prefix_] possibly causing an issue?
You cant disable prefix if not touch code,
But you can create databases whit diferent prefix if you insert database, user, and password (md5) in your db.conf and then rebuild databases this works, but then you can have probelms if rebuild database from gui or change password.
So just create new databases is easy way
But you can create databases whit diferent prefix if you insert database, user, and password (md5) in your db.conf and then rebuild databases this works, but then you can have probelms if rebuild database from gui or change password.
So just create new databases is easy way