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?
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.
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 ....
I've recently moved a popular forum from one dedicated server to two dedicated servers.
1 server for HTTPD
1 server for MYSQL
The forum is running very slowly, even though server load is low on both servers.
I have tried different mysql optimizations but nothing seems to be working.
Would anyone be willing to help me solve this issue? If so, please PM me. I am happy to pay for your time.
i am new to this and am in need of some help.. i have vbulletin 3.5.0 installed with photopost gallery and phpprobid auction...
I am hosted with fasthosts on a linux dedicated server, it is crap! it has been down 3 times in 1 month, the support is terrrible.. I have already movedit from pipex hosting due to lack of support for mysql. i canot keep moving my site, my brain will melt out of my ears ...
Can i link to my original install.. so if the fasthost server goes down,, could i have it directed to the old server? and can i keep the 2 databases current?
Hope i have explained it well enough... basically need a backup server setup for my vbulletin so, i dont lose potential new members..
My question may be simple to some but I have no idea on how to do it and dont want to cause server crash....
I have been offered part share in a server and the whm/Cpanel software is already there.
I dont want my customers details being shared wth the other party. Is there anyway I can set the whm/Cpanel software with root access so we can both use it but each others accounts are private.
I've just purchased a second server of which I wish to use a database server for a number of my databases and I'd like manage it remotely (from the web server) via phpmyadmin.
I've configured my firewall and granted access to the web server on root@webserverip and also username@webserverip (username being just one of the database accounts I wish to grant access in order to test this). Accessing mysql remotely from the webserver now works on both accounts (via ssh and php).
However, having configured the phpmyadmin config file to include the ip (network ip) of the 2nd server I am unable to see the 2nd server when logged in to phpmyadmin. I just have the usual root@localhost and username@localhost.
I have a tiny MySQL database (10MB) and I'm looking for some remote backup service. Someting that will backup the database and let me recover it if the host is in trouble.
I strongly prefer something simple and fully automated.
Is it a good idea to "Split" my dedicated into a couple of different VPS's?
1. My sites and hosting "Company" site.
2. Customers sites.
Would this be the best? I was thinking of putting the companies site on a separate VPS so that a malicious user can't use php to exploit the billing system. (I know it would be ideal to have 2 dedicated servers, 1 for customers, 1 for company, but that just isn't possible right now).
I have a 1GB MySQL database (compresses down to 300MB) and would like an automated method of backing it up to a remote server. Both accounts are shared hosting accounts (if it matters, both are running CPanel, no shell access on either).
View 13 Replies View RelatedWe will be migrating from plesk 9 to plesk 11 and I am having some trouble finding a fix for something. Previously, http and https could either share a directory or have split directories (httpdocs and httpsdocs) for a site. Now all I see is httpdocs and I can't find a way to have separate directories.
View 6 Replies View RelatedPRODUCT, VERSION, MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
Plesk 11.5, 11.5.30 Update #44, last updated at April 30, 2014 03:25 AM, Centos 6.5 (Final), Linux 64bit
PROBLEM DESCRIPTION
When I try to add an extra MySQL server, running on a different server, I always get an error that the user has no admin access. But the user I created does have admin access to the database.
The remote database is a MySQL 5.5 on a Linux Ubuntu 12.04 LTS server
STEPS TO REPRODUCE
Tools & Settings -> Database Servers -> Add Databases server
ACTUAL RESULT
Error: Test connection to the database server has failed because the supplied account does not possess administrative privileges: Access denied for user 'admin'@'%' to database 'd536cedf97037e'
EXPECTED RESULT
A working database connection.
ANY ADDITIONAL INFORMATION
These queries are logged by MySQL:
140509 16:54:51 28 Connectadmin@10.1.0.162 as anonymous on
28 QuerySELECT VERSION()
28 Querycreate database `BUG115166_1374110215536CEC3816DD2` /*!40101 default charset=utf8 */
28 Querycreate database `bug115166_1374110215536cec3816dd2` /*!40101 default charset=utf8 */
28 Queryinsert into mysql.user (Host, User, Password) values ('%', 'bug115166_17546', password('BUG115166_1374110215536CEC3816DD2'))
28 QueryFLUSH PRIVILEGES
[Code] .....
If I just ignore this message, go to a subscription and create a database, then the database gets created just fine. It's just Plesk that thinks that something went wrong.
Is it possible to use a remote database server on two or more Plesk installations without issue?
Plesk A (192.168.1.1):
Local MySQL (default)
Remote A MySQL (192.168.1.5)
Plesk B (192.168.1.2):
Local MySQL (default)
Remote A MySQL (192.168.1.5)
... etc etc. Is that possible? It'll allow me to create databases on the remote server from both/all the Plesk servers without conflict?
My company's domain is mycompany.com and we are hosting our corporate website in our own datacenter.
Now I want to create another website subdomain, site1.mycompany.com, to be hosted in an external third party datacenter.
Is it possible for me to send out email from the third party servers using the address info@site1.mycompany.com? I do not want to spoof any outgoing mail.