0
votes
1answer
92 views

WordPress - MySQL server has gone away

I have a WordPress install on a dedicated server with decent memory (upwards of 8GB). The WordPress install includes many plugins - 50 active plugins. Most important to note is the WPML plugin to ...
0
votes
2answers
51 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
0
votes
1answer
38 views

Unable to connect to IDAQ database from php

I'm having difficulties migrating a site to the clients host. The host is idaq.com. I've searched for ages and have found no actual answer or even close to one. I'm using the following connection ...
1
vote
1answer
80 views

Oracle SQLConnect: 1033 via UnixODBC

Here is the full error: PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08004] SQLConnect: 1033 [unixODBC][Oracle][ODBC][Ora]ORA-01033: ORACLE initialization or shutdown in ...
0
votes
0answers
95 views

Sleep processes in MySQL workbench

When I view server status in MySQL workbench I found out that there are a large number of proceeses with command "sleep". No active query is going on and I fear would it be the case that I ...
0
votes
2answers
85 views

Amazon RDS and users, security

By default you got a username and password for your RDS database. Would it be dangerous to use the credentials on your production website, say in php files? Or is it necessary to create a user with ...
0
votes
1answer
212 views

Binding MySQL to run from the public or private LAN IP address - which one is faster

So we have 2 servers all running at the same web host. We have bind MySQL to listen on the public ip-address of the database server and the web server connects to it from the public ip. Both servers ...
0
votes
2answers
526 views

Binding MySQL to run from the public or private LAN IP address - which one is faster [duplicate]

Possible Duplicate: Binding MySQL to run from the public or private LAN IP address - which one is faster So we have 2 servers all running at the same web host. We have bind MySQL to listen ...
0
votes
5answers
684 views

Move MySQL DB to another server

I have server with very big mysql database (160GB). How easy way to move this DB to another server?
0
votes
1answer
112 views

setting up a local database to be updated from a master database

I'm looking for an efficient way to keep multiple databases (on different servers) sync with a master database (also on a different server). Mind you I only need a one way sync (from master to all ...
0
votes
1answer
44 views

Test the proper execution and integrity of a backup

Every night my company generates automated backup all our servers on a backup server: -- backups folder ---- server1 backups folder ------ server1_backup_files.7z ------ server1_backup_db.7z ---- ...
2
votes
1answer
88 views

Strategies for protecting third party PHP web app config files

I'm interested in comments and strategies for protecting PHP config files, particularly those with Db credentials. The stock advice, set the file extension to *.php, is fine as far as it goes, but it ...
0
votes
3answers
110 views

should php be installed on apche web server or mysql database server

Setup: Two separate boxes: Fedora 15, Apache, PHP and PHP modules Fedora 15, MySQL I am unable to make a connection to mysql from Apache web server. <?php echo "<br>begin ...
1
vote
1answer
27 views

Splitting functionality on a server

Hi I was wondering the best way to setup my current application. Here is the general rundown. I have a phone application that uploads and downloads photos from a vps that will store the files ...
1
vote
2answers
136 views

Is it better to access a database from PHP using the external IP or the local IP?

I have a website that uses CakePHP and in the current database configuration the developer before me is using the public IP of our database server. Should I use the local IP when accessing the web ...
0
votes
1answer
456 views

Installing plaincart on hostgator

OK, so I am following this tutorial and I'm trying to deploy the sample code onto my MySQL and PHP web server over at Hostgator. OK, so I have all of the files contained in a folder called plaincart ...
0
votes
2answers
167 views

How to load another PHP's phpmyadmin to current PHP

In my application there are two PHP are available. 1) PHP 5.1.6 2) PHP 5.2.6 Currently I am using PHP 5.2.6 version in my application. Also I'm using PHP 5.2.6 database ( phpmyadmin ). Here my ...
2
votes
2answers
490 views

Can I convert my database/script to UTF-8?

How can I convert a database to support UTF-8 and convert it's old data from what ever encoding they're in to UTF-8 ? Extra Info: I'm running a server which has many websites on it, and one of them ...
4
votes
5answers
184 views

What statistics app should I use for my website?

I have my own server (with root access). I need statistics of users who visit my website etc etc... I have looked at an app called Webalyzer... Is this a good choice? I run apache2 on a Ubuntu 9 ...
0
votes
1answer
1k views

sqlite : Fatal error: Call to undefined function sqlite_escape_string()

I use a script that requires SQLITE, On my previous host, it worked. On localhost it works. On my new dedicaced server, it doesn't. I use PHP5 of course, you can access phpinfo() of the server. ...
2
votes
4answers
793 views

MySQL max_user_connections

We're releasing a site in a couple of weeks that has been developed on a local machine but now when were testing on dev server we get MySQL error 'max_user_connections'. We have talked to the ...
2
votes
6answers
925 views

PHP vs Batch file for mysql cronjob?

My server details: OS: Windows Server 2003 IIS6 Plesk 8.xx installed (currently using Plesk to set the cronjob) I need your advice. I have 2 methods: Method 1: Using php + mysqldump, create ...
0
votes
2answers
6k views

To get PHP communicate with PostgreSQL

My PHP code which I try to use in Firefox <?php // Connecting, selecting database $dbconn = pg_connect("host=localhost dbname=masi user=postgres password=abc") or die('Could not connect'); ...
1
vote
6answers
329 views

How do I protect the database server?

Currently my database user and its password are pretty easily to guess, eg. database user: dbadmin database pwd : super + companyname What and how to generate a secure a secure database password? ...
2
votes
1answer
2k views

Optimising PHPMyAdmin configuration for massive databases and many tables

Developers require database access to a significant number of databases, each with 220+ tables, and currently they are provided this using phpMyAdmin 2.11.9.5. Initial load is very slow, puts some ...