please help 8 years efforts are lost hostgator deleted webfiles have db backup

[yourdailysaver]

Hello Seniors,

i have my forum running at www.indian-femdom.com before 3 days hostgator has deleted all my webfiles. total of 40 sites lost but only this site uses smf.

i have db's left in there so i downloaded backup
i have changed my host installed db there and from script install i have installed smf 2.0 same version i was using in my forum. and later i changed settings.php with my db settings where i installed backup from my old hostgator backup.

now its showing database error. please help friends. its really my 8 years effort. cant afford to loose it. please.

[Kindred]

Well, from the error, it would seem that you don't have the correct database connection information in your settings.php file

[yourdailysaver]

it is correct sir even if i have checked db prefix . its same

[Night09]

Are you using the same SQL and PHP version?

[Shambles]

... hostgator has deleted all my webfiles

Tell Hostgator to repair what they did.

[Kindred]

well, fairly obviously, it is NOT correct -- otherwise your system would be connecting the forum without an error...

[margarett]

Run repair_settings and make sure that all settings are correct.
What is repair_settings.php?

If you have a backup of the database, don't worry you won't loose your content.
I would start by picking a decent host first. Was there a reason for them loosing all your sites?

I checked your site, you need to run repair_settings and change everyone to use default theme. You have a default theme confifured whose files are not present anymore, so your layout is messed.

[yourdailysaver]

Run repair_settings and make sure that all settings are correct.
What is repair_settings.php?

If you have a backup of the database, don't worry you won't loose your content.
I would start by picking a decent host first. Was there a reason for them loosing all your sites?

I checked your site, you need to run repair_settings and change everyone to use default theme. You have a default theme confifured whose files are not present anymore, so your layout is messed.

thank you all for replies . margarett i tried your steps and got below errors after changing settings in repair_settings.php

Notice: Undefined index: database_error in /home/asutoshdesai/public_html/indian-femdom.com/Sources/Subs-Db-mysql.php on line 594

Fatal error: Call to undefined function allowedTo() in /home/asutoshdesai/public_html/indian-femdom.com/Sources/Subs-Db-mysql.php on line 595

which two lines are as below,

$context['error_title'] = $txt['database_error'];
   if (allowedTo('admin_forum'))

[margarett]

I'm not sure. Mixed files, maybe...

I can check that for you (later) if you PM me login details to your host's control panel. I need to check both files and database in order to understand what's happening...

Isn't this an option?

... hostgator has deleted all my webfiles

Tell Hostgator to repair what they did.

[yourdailysaver]

I'm not sure. Mixed files, maybe...

I can check that for you (later) if you PM me login details to your host's control panel. I need to check both files and database in order to understand what's happening...

Isn't this an option?

... hostgator has deleted all my webfiles

Tell Hostgator to repair what they did.

sir they are such a loosers. deleted my 30 sites. and when i created tickets they are not even replying to it from last 3 days. i have changed to godaddy already. i send you id password in pm for my domain but the process of domain transfer is under process i guess so i think i will send you once its completed. so you can work on it. thanks for your time sir.

[a10]

i have changed to godaddy already

Out of the ashes and into the fire ? 

[Vince S]

For these cheapies in my experience it is daylight to second place after SiteGround.

10 years ago SiteGround were great, and they keep building substantial improvements of stuff I didn't even know I wanted with every passing year. I have considered lots of alternates over the years but always gone with SiteGround. This was originally an experimental use of a cheap non-Australian based host for a social website, but that has gone so well that when the last serious website I have expires it is going over to SiteGround too.

marg edit: referral removed

[Steve]

@ yourdailysaver - If you are wanting to switch hosts, this is a good place to start looking:

Hosts, Hosting and Commercial Services

And did you do as margarett suggested?

I can check that for you (later) if you PM me login details to your host's control panel. I need to check both files and database in order to understand what's happening.

[yourdailysaver]

I'm not sure. Mixed files, maybe...

I can check that for you (later) if you PM me login details to your host's control panel. I need to check both files and database in order to understand what's happening...

Isn't this an option?

... hostgator has deleted all my webfiles

Tell Hostgator to repair what they did.

i tell you what i have done,

i have installed same version of smf on my new server,
and importing my db backup in same db new smf has
i am getting below error while restoring my old db backup to my new db,

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 48
STR: ><
SQL:

<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="db_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60asutosh_india%60+WHERE+Name+%3D+%27smf_bfalog_spider_stats%27&amp;show_query=1&amp;db=asutosh_india&amp;token=519dce4cd2cbf1643ecdd97015a3789a"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a>    </p>
<p>
<code class="sql"><pre>
SHOW TABLE STATUS FROM `asutosh_india` WHERE Name = 'smf_bfalog_spider_stats'
</pre></code>
</p>
<p>
    <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code><br />
</div>

SQL query:

<!-- PMA-SQL-ERROR --> <div class="error"><h1>Error</h1> <p><strong>SQL query:</strong> <a href="db_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60asutosh_india%60+WHERE+Name+%3D+%27smf_bfalog_spider_stats%27&amp;show_query=1&amp;db=asutosh_india&amp;token=519dce4cd2cbf1643ecdd97015a3789a"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a> </p> <p> <code class="sql"><pre> SHOW TABLE STATUS FROM `asutosh_india` WHERE Name = 'smf_bfalog_spider_stats' </pre></code> </p> <p> <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a> </p> <code> #2006 - MySQL server has gone away </code><br /> </div>

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
<p><strong>SQL quer' at line 1

[Kindred]

First... How did you make the SQL backup?
Second, did you empty the error log and drop the search index (full or custom) before running your backup?

[yourdailysaver]

First... How did you make the SQL backup?
Second, did you empty the error log and drop the search index (full or custom) before running your backup?

i have exported backup in sql file before few days i lost my forum. and i dont know how to empty and drop search index sir. i am not that techy. can you please elaborate if possible ?

[Kindred]

You can drop the search index from the smf admin search index page...
You can empty the error log from the error log page...


But HOW did you create the backup? Did you use phpmyadmin? Your host control panel? Smf admin?

[Steve]

Wait a second. Quick question (not trying to hijack thread) ... is this necessary before doing backups or is this for the OP's situation?

Second, did you empty the error log and drop the search index (full or custom) before running your backup?

[Illori]

if they are using the admin backup that can help to get a clean dump. if the dump they have is too large those tables being reduced in size will let the dump be smaller and upload possible.

[yourdailysaver]

i dont know whats going on here. can anybody have reply for my me ? my site is down how can i log into admin

[Kindred]

I am not sure what we can do...   from that error, it looks as if whatever you have is not actually a clean backup of your smf database.

[yourdailysaver]

it is the backup i have explained clearly i have exported it in sql format from my php admin

[Kindred]

I am not sure what we can do...   from that error, it looks as if whatever you have is not actually a clean backup of your smf database.

[margarett]

What you have is not a (proper) backup. I'm quoting what you said in the previous page

<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="db_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60asutosh_india%60+WHERE+Name+%3D+%27smf_bfalog_spider_stats%27&amp;show_query=1&amp;db=asutosh_india&amp;token=519dce4cd2cbf1643ecdd97015a3789a"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a>    </p>
<p>
<code class="sql"><pre>
SHOW TABLE STATUS FROM `asutosh_india` WHERE Name = 'smf_bfalog_spider_stats'
</pre></code>
</p>
<p>
    <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code><br />
</div>

Look at the parts I bolded. Your server "died" during the backup operation. I'm sorry, your backup is trash

[Night09]

I would contact hostgator and ask for a copy of the last backup they had. As far as I know they have to keep all information for a certain amount of time.

[yourdailysaver]

What you have is not a (proper) backup. I'm quoting what you said in the previous page

<!-- PMA-SQL-ERROR -->
    <div class="error"><h1>Error</h1>
<p><strong>SQL query:</strong>
<a href="db_sql.php?sql_query=SHOW+TABLE+STATUS+FROM+%60asutosh_india%60+WHERE+Name+%3D+%27smf_bfalog_spider_stats%27&amp;show_query=1&amp;db=asutosh_india&amp;token=519dce4cd2cbf1643ecdd97015a3789a"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" /> Edit</span></a>    </p>
<p>
<code class="sql"><pre>
SHOW TABLE STATUS FROM `asutosh_india` WHERE Name = 'smf_bfalog_spider_stats'
</pre></code>
</p>
<p>
    <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
</p>
<code>
#2006 - MySQL server has gone away
</code><br />
</div>

Look at the parts I bolded. Your server "died" during the backup operation. I'm sorry, your backup is trash

is there anyway i can send you full backup i have ? the thing is i found another backup as well. which is 145 mb in size but when i import it to my new hosts db through phpmy admin that process never ends i have tried it for let it running for two days . and it created db with size of 450 mb . and that to process never finished i have closed windows in between after let it run for 2 day.

[yourdailysaver]

and i have tried installing fresh copy of smf on my domain and changed database details to my db where i stored this backup and it shows me Table 'iff.smf_bfasettings' doesn't exist this error.

[Kindred]

That is the point we have been trying to make. What you have is not a complete backup and will never work. You need to get the actual data from your host

[yourdailysaver]

i can still see full db in my hostgator panel those loosers not even replying to my tickets from 7 days. can anybody tell me how to backup the whole db its 1000 mb in size and when i am trying to export it from phpmyadmin it gets crashed always.

[Shambles]

Grab a copy of MysqlDumper (it's free).

[yourdailysaver]

Grab a copy of MysqlDumper (it's free).

i am using shared server of hostgator. how to use this tool ?

[Shambles]

It can run from within your browser. Just configure it then let it loose.

http://www.mysqldumper.net/

[yourdailysaver]

It can run from within your browser. Just configure it then let it loose.

http://www.mysqldumper.net/

yes sir worked it out its dumping. now i need to install mysqldumper to my new host too where i want to restore this dump ?

[Shambles]

Err... yep

[yourdailysaver]

Err... yep

thank you sir i guess it will solve my problem. one more thing my new host allows me only 1 gb in single database and i guess my forum is already above it when i was with host gator. what should i do  ?
if i want to reduce size

[yourdailysaver]

another thing i want to know is i might have full db backup now. but i dont have webfiles at all. whats the procedure and steps to take while i try to restore my site on new server ?

[Shambles]

http://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files


Start from point 3.

[yourdailysaver]

not even able to download 118 mb's sql dumb from hostgator. crashed 12th time in last 5 hours at 39  to 70 mb. hell with hostgator. beware of this fraud hostgator guys. i am using 12 mbps internet and not able to download 118 mb file . huhhh.

[a10]

^^^ try downloading individual tables (then rebuild complete db by restoring one by one). Needs extra time, but it may hopefully work, good luck. See attach.

[yourdailysaver]

something strange. finally i am able to get dump from hostgator backed up now not able to restore it to godaddy. its gettin timeout now.   all hosts are same or what ?

[margarett]

Hostgator and Godaddy? Yes, they are both the same "thing".

You need to get yourself a GOOD host. Not one of those "unlimited everything". As you can see for yourself, they are beyond limited...
If you still can, cancel your Godaddy service and hire a good host. Check your "hosting" boards for good ideas

[yourdailysaver]

Hostgator and Godaddy? Yes, they are both the same "thing".

You need to get yourself a GOOD host. Not one of those "unlimited everything". As you can see for yourself, they are beyond limited...
If you still can, cancel your Godaddy service and hire a good host. Check your "hosting" boards for good ideas

can you suggest any please ? i am tired trying everybody one by one.

[yourdailysaver]

i am getting message like The server closed the connection without sending any data. whenever i try to restore my dump into new godaddy server. please check the attachment.

[margarett]

http://www.simplemachines.org/community/index.php?board=155.0
Any of the hosts in this board are reputable. And of course, many others that are not announced here.

[yourdailysaver]

i guess now i know why i am not able to restore db to godaddy. because my hostgator backup is when extracted its 1.5 gb sql file. and godaddy allows only 1 gb per single db. can anybody suggest me if its possible for me to delete old threads of mine forum and restore small db to godaddy ?

[Kindred]

Call godaddy support and have them help you

[margarett]

1.5Gb? How big is your forum?

[yourdailysaver]

1.5Gb? How big is your forum?

please do check your inbox

[margarett]

my hostgator backup is when extracted its 1.5 gb sql file. and godaddy allows only 1 gb per single db

And this is (also) why we don't like Pretty URLs...
I am looking at your database at hostgator right now. Your second biggest table is "members" with 176,170 records and 55,7 Mb
Your biggest table is "pretty_urls_cache" with 4,879,196 records and 892,7 Mb

If you take this database out of the equation, your database will become small and tiny and easy to move from one side to the other...

Note: in defense of Hostgator, your control panel is a terrible mess no offense intended but you have 23Gb just on emails from i-don't-know-when

I fixed your forum paths with repair_settings and your forum is now running. If you want to export your database you will have to get rid of that huge table, which will reset Pretty URLs. Anyway, remember that, because you loaded fresh files, no MODs are in place and, of course, neither is Pretty URLs.

Let me know if you need further help

[yourdailysaver]

my hostgator backup is when extracted its 1.5 gb sql file. and godaddy allows only 1 gb per single db

And this is (also) why we don't like Pretty URLs...
I am looking at your database at hostgator right now. Your second biggest table is "members" with 176,170 records and 55,7 Mb
Your biggest table is "pretty_urls_cache" with 4,879,196 records and 892,7 Mb

If you take this database out of the equation, your database will become small and tiny and easy to move from one side to the other...

Note: in defense of Hostgator, your control panel is a terrible mess no offense intended but you have 23Gb just on emails from i-don't-know-when

I fixed your forum paths with repair_settings and your forum is now running. If you want to export your database you will have to get rid of that huge table, which will reset Pretty URLs. Anyway, remember that, because you loaded fresh files, no MODs are in place and, of course, neither is Pretty URLs.

Let me know if you need further help

you really saved my life. i am very thankfurl to you. just last help is if you can remove that pretty url table or whatever you think we can remove to make db smaller. so that i can move it to godaddy. it will be great help really you saved my life.

[margarett]

OK the table was TRUNCATEd do your database is now reasonably small.

Good luck

[yourdailysaver]

OK the table was TRUNCATEd do your database is now reasonably small.

Good luck

yes its good now. thank you very much. you are great. i just thought pretty url's are good for seo so used it. didnt knew that it takes this much space in db.