UNiTE, Remote CLI, eXtract Wizard

Sunday, 26 September 2010 00:27 CDT

user13787

Hey There !!!
I used akeeba backup to take backup of my site and could do it perfectly. The .jpa file was approx. 151 MB.
I uploaded the same, as well as the kickstart.php file on a new server of the same hosting. I was able to run that(/kickstart.php) and the restoration went upto 60% when i recieved the following error:
Error at the line 97: INSERT INTO `akb_joomlawatch_ip2c` VALUES ('3276517904', '3276517951', 'NL') ... MySQL: MySQL query failed with error 1226 (User 'vijay_app' has exceeded the 'max_questions' resource (current value: 75000)). The query was:INSERT INTO `akb_joomlawatch_ip2c` VALUES ('3276517904', '3276517951', 'NL')
I have PMed you the same with the url of my site
Please look into this.

Sunday, 26 September 2010 10:13 CDT

nicholas

User 'vijay_app' has exceeded the 'max_questions' resource (current value: 75000)

Your host is imposing a limit on the maximum number of database commands you can execute per hour. It is impossible to restore a site on such a host either automatically or even manually. Ask your host about the possibility to migrate your site. If they are not willing to help, cancel your subscription with them and find a decent host which doesn't impose such limits, such as Rochen.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Monday, 27 September 2010 13:14 CDT

user13787

Hey Nicholas !!! Thanks a lot. I know that hosting sucks ... still since i took it i requested them onthis issue and they sent me this reply :

I would like to inform you that, please upload the database backup file in the '.sql' format and get back to us with the exact location, where you have uploaded. Also, please provide us the exact MySQL database, so that we can import it from our end.

What does this mean and how can I actually do that thing as in the step by step process of the whole thing which he asked. And what is he actually trying to do. Please help :)

And one more thing you are hosting this on a Rochane hostings or do you people have your own servers ???This is an off-topiv question though !!!

Tuesday, 28 September 2010 01:55 CDT

nicholas

Hmpf... Well, you can do that. You have to follow the the emergency restoration procedure outlined in our documentation, with one tweak: instead of restoring the SQL files yourself, you will have to put them in the site's root and ask your host to restore all of them one by one (joomla.sql, then joomla.s01, then joomla.s02 etc). After they have done so, you will have to edit the configuration.php file manually. This is a kludge, but you have to live with that if you want to use that host. Also note that you might not be able to backup your website due to the same query limit limitation, as Akeeba Backup needs to make quite a few SQL queries to your database in order to backup your website.

Regarding our hosting, we are hosted on a normal Rochen account. We don't have a dedicated server, because we frankly do not need one. Rochen undersells their servers. This means that if a server can theoretically host 1000 sites without a as much as a hickup, Rochen will only host 100-200 sites on it, so that if a sudden traffic surge happens the server won't have any issue at all. One day I saw our traffic sky-rocket to ten times the average and there was absolutely no lag. Rochen is, simply put, one of the best hosts out there. Very fast, very helpful and their prices are dirt-cheap for the service quality they offer.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Tuesday, 28 September 2010 05:38 CDT

user13787

Thanks LLLOOOT !!! :) I will try that and get back to you. Thanks again. The sit is too cool , You have a solution for probably anything.

Tuesday, 28 September 2010 07:46 CDT

nicholas

I'd wish! I have a solution for most Joomla!-related issues, just not for everything :D

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Saturday, 09 October 2010 20:34 CDT

user13787

Sir, can you please tell me how to differentiate between the command part & data part of aDatabase command. You asked to change "#__ " part of COMMAND PART to " jos_ ", & not of data part. My question is how to differentiate between the both so that i can proceed with it.

Sunday, 10 October 2010 10:46 CDT

nicholas

It's quite easy. If the line starts with CREATE TABLE, replace all occurrences of #__ with your site's prefix (I assume it's jos_). If the line starts with INSERT INTO `#__ then chnage it to start with INSERT INTO `jos_ and you're done :)

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support