I am trying to restore a MASSIVE database but it is just not have any of it the cashcrusader will only restore 4000kb
Can anyone please help a reward will be offered!
Full Version: Urgent help required
Get Paid Forum - Get Paid Discussion > Webmaster's Corner > General Discussion on Building, Running & Making Money from a Website
QUOTE(chris35 @ Mar 11 2005, 07:42 AM)
I am trying to restore a MASSIVE database but it is just not have any of it the cashcrusader will only restore 4000kb
Can anyone please help a reward will be offered!
[right][snapback]3339117[/snapback][/right]
Can anyone please help a reward will be offered!
[right][snapback]3339117[/snapback][/right]
OMG Chris, when I saw your post I suddenly remembered I was supposed to help you restore a db a couple weeks ago. Something came up and I totally forgot, I'm sorry
For the database you're trying to restore now, do you have shell access to the server? If you do, I'll give you instructions for restoring a db in shell, it's very very easy that way, even with a HUGE db.
I can probably get shell, do you meen on my current server or old server?
Thanx No probs
Thanx No probs
Here's instructions for restoring in shell, it's so incredibly easy and will allow you to restore very big databases (I did one the other night that was over 20mb)
First, upload your db backup into public_html (you can use another directory, but if you do you'll need to make sure you use the correct path in the command line. I am writing these instructions based on the backup being in public
Then in the following code, change the details to your own, as indicated by the colored text.
This MUST all be on one line.
mysql -umysql_username -pmysqlpassword database_name < home/account username/dbbackupfilename
Thus if the following is true, lets say:
your site is chrisptr.com
your account username is chris
your backup is backup.sql
your mysql db username is cash
your mysql password is guesswhat
your database name is dollars
then you would have
mysql_username = chris_cash
mysqlpassword = guesswhat
database_name = chris_dollars
account username = chris
dbbackupfilename = backup.sql
That would make your command look like this (remember, all one line)
mysql -uchris_cash -pguesswhat chris_dollars < home/chris/backup.sql
First, upload your db backup into public_html (you can use another directory, but if you do you'll need to make sure you use the correct path in the command line. I am writing these instructions based on the backup being in public
Then in the following code, change the details to your own, as indicated by the colored text.
This MUST all be on one line.
mysql -umysql_username -pmysqlpassword database_name < home/account username/dbbackupfilename
Thus if the following is true, lets say:
your site is chrisptr.com
your account username is chris
your backup is backup.sql
your mysql db username is cash
your mysql password is guesswhat
your database name is dollars
then you would have
mysql_username = chris_cash
mysqlpassword = guesswhat
database_name = chris_dollars
account username = chris
dbbackupfilename = backup.sql
That would make your command look like this (remember, all one line)
mysql -uchris_cash -pguesswhat chris_dollars < home/chris/backup.sql
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.