transporting database

[cryogenikz]

im moving from one hosting server to powweb.com, i ran a database backup last night but how do i go about moving that database to the new one? also.. where is my database at powweb.com?

[cryogenikz]

forgetit, i found the announcement :)

[cryogenikz]

i get this message when i try to login to phpmyadmin
#1045 - Access denied for user: '*******@phpmyadmin.powweb.com' (Using password: YES)

why cant i log in? i typed in the username and password i chose during registration

[HalfaBee]

Your username is CaSe SenSitive.

Make sure it is exactly as you put it in ops.

[cryogenikz]

forgetit.. i got it :D

[cryogenikz]

alright.. heres the problem im fighting through right now... my database backup from the old hosting server is more then 1MB, specifially.. its about 23.5MB total! so whenever i try to transport my database, it times out. Also, everytime i try to open up the database file with notepad, the program freezes because the sql database backup file is just too large.


what do i do? do we have telnet or SSH access here at powweb?

[HalfaBee]

You will have to upload your DB, then split it into smaller peices.

Use this php script

<? exec( 'split -l71000 db.sql' ) ?>

It will split the file into 71000 line files called xaa xab ...

23MB wil be about 4-6 files.

You can then restore them one at a time.
Use 3 mysql users and you can restore 3 per hour.
Do them in the correct order.

[cryogenikz]

what do i name that file? and what directory do i put it in? the root directory?

[HalfaBee]

Call ir split.php and put it in htdocs or a dir in htdocs.
Put the sql file in the same dir and call it db.sql

Run the split.php and restore the files.

[cryogenikz]

Originally posted by HalfaBee
Call ir split.php and put it in htdocs or a dir in htdocs.
Put the sql file in the same dir and call it db.sql

Run the split.php and restore the files.


THANK YOU!! marry me!.. please do!! lmao :D haha

[HalfaBee]

Thanks for the offer, but ...

Happy to see it worked.

[cryogenikz]

one probelm.. when i try to download it from my server onto my pc so i can send it over to the database... it times out or something halfway through. does this happen alot? do i need to change the file extention? or is there a way to send these broken up files over to the database directly from my webspace without having to dLoad it, then sqLing it to the database?

[HalfaBee]

You don't need to download the split files.
Have a look at the first STICKY thread to find a link to a small script I wrote to do backups/restores.

[cryogenikz]

i downloaded the file in your thread and it came out as a blank file.. did i do something wrong

http://forum.powweb.com/showthread.php?s=&threadid=20022

[cryogenikz]

i tried again by right-click > save target as, and it worked