LinuxQuestions.org - Database transfer issues

- Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)

- - Database transfer issues (https://www.linuxquestions.org/questions/linux-server-73/database-transfer-issues-4175582881/)

Database transfer issues

I am transferring a 38.7MB databse from a shared hosting plan (managed) to an unmanaged server. This is a vBulletin 5 (the newest / current version of the script) database, which is suppose to contain the actual picture files in it (like .jpg and .png). There is an option to serve images from the filesystem there, but I've never changed it to this, so I guess the images would be there.

I've been trying it several times (chroot jail ssh access to there, and full access to root on the target hosting) and it does not seem to work. The forum works, but the logo does not display (like 95% of the time, 5% it would show), and I am not able to reply to posts or add posts. 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.

So the vBulletin support person told me to ask the hosting people to create a database dump with better permissions. I am not sure whether this can make any difference, but I got it now. I downloaded it with Filezilla in a binary mode, and I uploaded it to the self-managed hosting plan through the sftp too.

So I have that 38.7MB .sql file, and I will be importing it there for the 4th time, and it may not work.

Is there any way to figure out what the problems may be, get some kind of verbose output and so on. I would need to know what the exact problem / error or erros are and go from there.

I've found this so far:

https://www.psce.com/blog/2013/04/17...h-sql-imports/

Things like:

Code:

cat dump.sql | mysql --show-warnings test

Code:

cat dump.sql | stdbuf -i0 -o0 -e0 mysql --show-warnings --verbose test 2>&1 | sed -n -e '/^----/{h;:a;n;/^----/{H;b b};H;b a};:b;/^(Warning|ERROR)/{H;x;p}'

Quote:

Originally Posted by AdultFoundry (Post 5565085)

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:

Code:

mysql -uuser -p

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?

Quote:

Originally Posted by AdultFoundry (Post 5565085)

vBulletin only stores the ATTACHMENTS in the database, things like the logo, icons, etc. are served from the file system.