Bigdump error " Page unavailable or wrong URL

[Pirate]

Change the $linespersession variable in the bigdump php file to a lower number.

Try with 1000 or 500. If don't work, try with 200, but that's brutal slow.

 

[DeLeTeD]

I think the db is corrupt tbh

 

[Lock Down]

well i don't know. am on shared hosting using cpnael

If you have cpanel you can create a cron job to run the command.


Just upload the mysql dump which I presume you have done to your site in sql format.

then add a cron job choose once an hour.
add this to the command line:

mysql -u your_username -pYour_password your_databasename < /home/yoursite_abbreviation/public_html/your_dbbackup.sql

Most abbreviations are the first 8 characters of your site name and if the sql file is in a folder other than root you have to add that after the public_html like
/home/yoursite_abbreviation/public_html/backups/your_dbbackup.sql

 

[Arthur]

well lock down. Thank you very much for your kind reply. But i do not how to run cron job. Its new thing for me

Can you please more elaborate about it? would be appreciated

 

[Lock Down]

In cpanel look under advanced and you will see a icon cron jobs. Click it.

Now choose twice an hour for the Common Settings.

in the box next to Command: add the

mysql -u your_username -pYour_password your_databasename < /home/yoursite_abbreviation/public_html/your_dbbackup.sql

using your information for the bold part.

Then choose add crojob. Next add your email where it says cron email.

Check every 10 minutes to see if you have an email or if the datbase is loaded. When it finishes delete the cronjob or it will continually overwrite the database.

 

[Arthur]

U sure it will load the DB in just 10 minut? do i need WHM access as well? or is there any size limitation? as my db is about 800MB

 

[cyber.crime]

that file 800MB in txt file or gz

 

[Arthur]

its not txt its .sql file

 

[Pirate]

Do you tried my method?

Change the $linespersession variable in the bigdump php file to a lower number.

Try with 1000 or 500. If don't work, try with 200, but that's brutal slow.

 

[Arthur]

Well ya i tried it with 500 but dosn't work man

 

[Lock Down]

500mb is nothing if your server is set properly. Mine took less than 1 minute.

Just run it. WHat have you to lose.

It will start ether at the hour or half hour usually. Not the second you enter the cron. Also clear the database of all data not truncate but delete all tables from the database before you enter the cron.

 

[Arthur]

well ok i will see that... let me try that method

 

[Arthur]

Hello man, i did this but cron job was not started... even i wait for more than 20 minutes