MySQL Transfer

[HH-Steven]

Ok, i have a customer whos wanting to upload a fairly big database. I told him to upload it to his public_html folder with the understanding that i can use ssh to add it to the sql folder etc........

Hes uploaded it but now im stumped, is there anyone who could give me a step by step on how to complete this?

DB - techmob_ipbnuke.gz (and is located in the customers public_html directory)

Thanks in advance for any help.

Steven

[anup123]

tar xvzf techmob_ipbnuke.gz

mysql -uUSERNAME -pPASSWORD DATABASE_NAME < YOUR_FILE/YOUR_FILE.sql

Where YOUR_FILE/YOUR_FILE.sql is what you wouild get from first command.
Substitute USERNAME , PASSWORD, DATABASE_NAME with the values that you have for the user

Anup

[HH-Steven]

Ok, tried that, this is what i get after the first command :

root@server1 [/home/techmob/public_html]# tar xvzf techmob_ipbnuke.gz
tar: This does not look like a tar archive
tar: Skipping to next header
tar: Archive contains obsolescent base-64 headers
tar: Error exit delayed from previous errors


Any suggestions?

[anup123]

Google around

Anup

[Marty]

It didn't work because, like the error said, it is not a tar file. Try this:

gunzip techmob_ipbnuke.gz

mysql user_dbname -u user -p**** < /home/username/techmob_ipbnuke

[anup123]

tar <options>

x - extract files from an archive
v - verbose
z - filter the archive through gzip

It always worked for me provided the file was not corrupted (many reasons for that ... something silly like uploading the compressed archive in ascii mode)

Anup

[Marty]

tar <options>

x - extract files from an archive
v - verbose
z - filter the archive through gzip

It always worked for me provided the file was not corrupted (many reasons for that ... something silly like uploading the compressed archive in ascii mode)

Anup

I may be wrong, but I am pretty sure that should only work on a file that was tarred AND gzipped. In this case, the file is only gzipped.

[HH-Steven]

Thanks for the reply guys, ill have to try them tomorrow, ill let you know.

Cheers
Steven

[DigitalN]

Login as root:

gunzip techmob_ipbnuke.gz


If they haven't added the db in cpanel yet, with a user, password then..

# mysql

> CREATE DATABASE techmob_ipbnuke;
> GRANT ALL ON techmob_ipbnuke.* TO $user@localhost IDENTIFIED BY '$password';
> FLUSH PRIVILEGES;
> quit

# mysql techmob_ipbnuke < techmob_ipbnuke (the last one is the name of the sql file)

Change $user, $password to the real database user and their password respectively, which they can let you know if you can't see it by checking their mysql connection script that is located on their account, if it is there.

Otherwise if the db exists already , just

# mysql techmob_ipbnuke < techmob_ipbnuke

Should do.