Quote:
Originally Posted by AdultFoundry
It is showing me a message that there is some database problems, and I dont get an email about what is wrong, even though I have it set to that.
Is there any way to figure out what the problems may be, get some kind of verbose output and so on.
|
How about start with the actual error message instead of "some database problem"?
Code:
grep problem /var/log/apache2/error.log
Migration 101:
Export the desired db using
Code:
mysqldump -u<user> -p <db> > /path/to/dump.sql
38.7MB is not that bad.
Now for
permissions...
You'll need the VBulletin.php "user" and "pass"
These are stored in the DocumentRoot of that software, or there abouts.
Once you know them, or the place they are stored, use them to give access in the form of "grant all..."
mysql >
Code:
create database vbulletin <options> <if> <any>;
grant all privileges on <dbname>.* to 'vbull_soft'@'localhost' identified by 'pass'; flush privileges; exit;
Notes about the grant statement:
Those symbols are single quotes and are required in that format. 'name', 'pass',
In the above example, 'vbull_soft' would be vbull_soft as the mysql "user"
allowed to connect from the localhost serving mysql.
now to test your credentials for vbulletin:
NOTE: Don't issue single quotes in this manner for the user, or pass.
Only in the grant statement.
You could also use these credentials and/or as alternate verification that the creds are correct using them in
the searhandreplace interface.
Importing:
as root:
Code:
mysql -uroot -p <db> < /path/to/dump.sql
The dump.sql may need to be "cleaned" for the new host. Posts into the db are likely to point to the original.
I gave you the searhandreplace link earlier, It will work on the imported vBulletin db also.
Advice:
I suggest that at this time, you change all of your software's passwords.
New passwords on new hosts. (
Shame on you LinuxMint.com)
Don't take any chances.
New house has new locks, yes?
Watching your progress...
Was the former host a cPanel affair?