VBulletin Database Restore
Jun 16, 2007
I have a site which uses vBulletin. After a long story we ended up with the need to restore it's database from a backup.
The backup proccess was in fact copying the database files - .MYD, MYI; so no mysql dumps.
I've recreated the dabase from phpmyadmin and created a standard user wtih read/write permissions and a dba user.
After that I've copied the database files from the backup and when I've tried to launch the site, it gives me the error:
"Warning: mysql_query(): Unable to save result set in /includes/class_core.php on line 354"
That's all the output I get.
I've modified the files permission to 755 and changed the owner and group; I've modified the vBulletin file to use the dba user account to access the database... all this without any luck.
I've done some searching and I've found that restoring database .MYI/.MYD files is simple - stop mysql, copy files, set permissions and fire up mysql. I've replicated the steps but still doesn't work.
View 3 Replies
ADVERTISEMENT
Dec 7, 2008
Don't know if it is some kind of attack or this is normal but the Server load goes reaching 20 in most of the times and may be greater!
this is the mysql_process list
jarabhar_JUHyyuh is opening alot of connections in the same time and this is not the normal behavior ....
View 2 Replies
View Related
Jul 4, 2008
I have one server setup to power my forum and its database. It has been running from this server for a while now and as the site gets bigger i have decided i want to move the database to a seperate server.
I have another server at Ecatel and wanted to know if its possible to do this, as they are in seperate datacenters.. or is it only possible between two servers on a private network in the same DC?
View 6 Replies
View Related
Apr 7, 2007
I have on my server vBulletin 1.7GB database in SQL format I try somany time to restore it but its hang! I transfer that file to another server and its working fine!
I see the MySQL Processes:
Code:
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
| 11 | leechprotect | localhost | leechprotect | Sleep | 2073 | | |
| 22 | eximstats | localhost | eximstats | Sleep | 1902 | | |
| 25 | xxxtyyx_vb | localhost | xxxtyyx_vb | Query | 1494 | Repair with keycache | /*!40000 ALTER TABLE `post` ENABLE KEYS */ |
| 41 | root | localhost | | Query | 0 | | show processlist |
+----+--------------+-----------+--------------+---------+------+----------------------+--------------------------------------------+
Its stay like that for long time!
View 7 Replies
View Related
Apr 24, 2008
i found out that for the past 6 months ive been backup up all my MySQL databases into one big file. However, now that i actually need to restore a database, i can't find out how to actually restore 1 database out of this enormous file.
I can find the Mysql shell command to restore 1 database ... but it doesnt tell me if you need to have a 1 database dump file for this as well. It does not mention what happens if you execute that command on the big file containing all databases. Restoring all server databases would be a very bad thing.
View 7 Replies
View Related
Apr 30, 2008
if you have used BQ internet remote backup
If you loose a DB how do you use BQinternet to restore the DB?
one particular DB
where is it stored?
View 5 Replies
View Related
Jun 10, 2007
my site is down for 2 days. this started 2 weeks ago when the vps started to work very bad and my site has been down more time than up. they closed the topic: "horrible experience with liquidweb" [url] but I still have not a solution and now somebody accidentally I suppose, deleted the database.
I cant do nothing and my last backup i have here is from +1month ago..
in cpanel I see: "sql disk usage": 120 mb but in databases zone it doesnt appear and phpmyadmin access is denied.
forum cant be accessed:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/.../public_html/forum/db/mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/.../public_html/forum/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/.../public_html/forum/db/mysql4.php on line 331
phpBB : Critical Error
Could not connect to the database
what can I do? can they restore it?
My sport community is in the worst nightmare I could imagine :-(
View 8 Replies
View Related
Dec 14, 2013
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
View 2 Replies
View Related
Jun 24, 2015
I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
View 1 Replies
View Related
Mar 8, 2015
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
View 1 Replies
View Related
Jul 22, 2015
Unable to restore database '17'
Not valid backup:
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.).
VERIFY DATABASE is terminating abnormally.
(Error code 22)
---------------------- Debug Info -------------------------------
View 1 Replies
View Related
May 2, 2013
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
View 2 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
Mar 23, 2015
Would like to know what are the dangers of backing up and restoring full entire system backups (with plesk installed) to another server with a different ip address? Will the restored plesk setup operate properly and offer an ip address change in the system, or will there be any pre-requisites required such as manual ip changing within the system core files?
View 1 Replies
View Related
Jun 1, 2009
i run a vbuletin forum, right now i am on a virtual dedicated
All my ips are stored on the same root ip, i am moving one of my forums from the default IP to a separate IP. I populated the DNS and my webite shows up properly on the new IP, but my forum is comming up as a database error.
Does anyone know what I can do to fix the problem? Or tools I can run? Or is it merely not connecting to the database yet, because of some name server or other issue?
View 4 Replies
View Related
Oct 25, 2009
My site has outgrown my current host and I'm strongly leaning towards a vps. I am relatively inexperienced with web hosting as for the last 18 months I've had very few issues with my current host (Stream101.com). They are currently saying my site is very memory and processor intensive which is why I'm going to have to leave them soon(I can't pay the dedicated server prices that would give my site the stability I desire).
About my site:
My site has 18,000+ users, its about 18 months old. 5,632 threads, 78,967 posts. It used about 150gig of bandwidth last month. The site is growing quickly (IMO). The site makes some money, but not enough to justify spending what it would cost for a dedicated server.
I'm happy to provide any other information, but what I am looking for is suggestions on:
1) Is a VPS the right choice for my site in your opinion.
2) What hosting company's would you suggest I look into.
3) How much ram/processor speed should I be looking for
4) any other information you feel I should know about this.
View 9 Replies
View Related
Jul 14, 2008
I installed Team plus this vbulletin mod integrated into my vbulletin database
[url]
I'm getting the below error when attempting to connect to my TS:
[17:46:38] No reply from server
Maybe the server is offline
or maybe teamspeak is not running on it
However, the server is running on PID 2967
In CSF firewall, I have these enabled
TCP_IN = 8767,51234,14534
TCP_OUT = 8767,51234,14534
I tried the main server IP and even the IP that the domain is hosted on.
For http port, I also tried 80 default. I have no idea what goes in "server id" anyway.
View 3 Replies
View Related
May 2, 2008
I am on a VPS with Centos 4 OS and Cpanel/WHM.
I am going to soon be upgrading to the latest version of vBulletin (3.7.0). They are recommending PHP 5.25 with APC installed. I am talled that Zend (which I have installed and eaccelerator) is not compatible with APC.
The vBulletin people say that APC will perform better than Zend, and that zend should be disabled and APC installed and enabled.
A couple questions.
1. I'm curious what people's opinions are on here about APC vs. Zend (eaccellerator) or possibly xcache.
2. I have once been told that APC and xcache aren't compatible with Cpanel/WHM. Is this correct?
3. Assuming 2 isn't correct, if I decide to move to APC, what do I need to do to disable/uninstall Zend/Eaccellerator and install/setup APC?
View 0 Replies
View Related
Jun 25, 2008
whenever someone tries to upload a .jpg image on vBulletin that uses imagemagick it says invalid format or whatever however when I test via shh.
[root@liquidwind jpeg-6b]# /usr/local/bin/convert logo: logo.jpg
[root@liquidwind jpeg-6b]# /usr/local/bin/convert logo: logo.gif
[root@liquidwind jpeg-6b]# /usr/local/bin/convert logo: logo.png
[root@liquidwind jpeg-6b]# /usr/local/bin/convert logo: logo.tiff
[root@liquidwind jpeg-6b]#
View 10 Replies
View Related
Jan 31, 2008
I have root access my friend told me it's a problem with apache or something. Anyone have any idea how I can solve this?
View 8 Replies
View Related
Jul 14, 2007
I have the max vars and all that set right to conform to vbulletin, Only problem is now I keep getting this in /var/log/messages
suhosin[8569]: ALERT - script tried to increase memory_limit to 4294967295 bytes which is above the allowed value (attacker '*******', file '/home/user/public_html/includes/class_xml.php', line 35)
The line its pertaining to is @ini_set('memory_limit', -1);
I'm pretty sure its not blocking anything, least nothing I see but it does this everytime someone accesses certain pages on a forum.
My memory_limit for php is 60 mb, I checked out different ways of configuring it, but the only thing I think would stop the alerts is setting the suhosin memory limit to 4 gb, as it says the script is calling for that. But I suppose if there was a crappy or malicious php script they would easily be able to ini-set and suck all the memory.
So basically what i want to do is just disable this alert as its filling the messages up. Has anyone dealt with this before?
View 6 Replies
View Related
Dec 22, 2007
Anyone here have problem with Mod_Security and VBulletin ? Currently running Apache 1.3.x and Vbulletin 3.6.8 patch 2 and want to install Mod_Security on Apache so I want to know if there any conflict with Mod_Security and Vbulletin.
View 3 Replies
View Related
Jul 25, 2007
I am running about 20 servers with default exim configuration that cpanel
writes on the servers.
One of the servers get a very high load when some of the customers send
mails to
His clients through the VBulletin script.
These mails doesn't exceed 20 thousand mail , and when he sends load goes
very high,
However other servers sends maybe 40 thousand mails without a big problem ,
and with same configuration and specification.
What can I do , or where can I work around to decrease the exim consumption
of the load like that.
I' $ve tried queue_only_load=6 but no any benefit :-(
View 0 Replies
View Related
Jan 26, 2007
1) From time to time my vbulleting message board loads slow, and at that time the server isn't even at a high load this happen at loads 0.9 nothing much really but always below 4.
2) Not only does it load slow but it often return the server cannot be found error, this minute it works fine and the next minute it doesn't, all i can see from the error log for my domain is
3) php warning: Zend Optimizer for PHP 4.3.x cannot be found (expected at '/usr/local/Zend/lib/Optimizer-2.1.0/php-4.3.x/Zendoptimizer.so') - try reinstalling the zend optimizer in Unknown on line 0, referer [url]
4) Does vbulletin relies on zend at all to be fully functional?
5) will zend actualy help at all?
Yes there are other sites on the box and they seem to work fine.
rhel4, ensim X 10.1 with all hot fix to date.
php4
mysql4
View 1 Replies
View Related
