Hello, I have 8 databases. I understand that I have to keep an error log, query log and a binary log. But I don’t understand the steps in how to maintain these databases. Can anyone explain the steps for mysql database maintenance?

I'm using a 15-inch MacBook Pro with OSx Mountain Lion. I'm using MAMP that came with MySQL. The default MySQL port is 3306 but seems like MAMP is running on port 8889. How do I port in PHP 8889 MySQL?

Hi everyone,

We have a large customer’s database in MS access.  In recently, it is getting stuck when we work in our network, so my boss needs to make a new database for our company, we are planning to use MySQL server for develop a new database. I want to know, will it be totally protected our data with having SQL copy database as backup?

Hello ! I am working on GPS web applications database in MySQL.

While creating a listing's I am getting an unexpected error.Code is mentioned below :

DROP TABLE IF EXISTS golook;
CREATE TABLE golook(
     lon FLOAT,
     lon FLOAT,
     address TEXT,
     title TEXT,
     url TEXT,
     summary TEXT );
Kindly provide me solutions.Thanks

Hi TechyV,

Whenever I try to connect through filezilla, I get the following error message that informs me of,

“Mysql error: MySQL server has gone away”

 At the moment my site along with my ‘phpmyadmin’ get down with errors like this. A few days earlier I changed the tables in the database of mine.  In Mt .Inc files (IE, PHP code), I just added some more. Since then it is troubling me.

Is there any way to get rid of it?

Thanks for the solution. 

Is it possible not to overwrite an existing file using a ZIP file when making a regular backup and putting it on XYZ.com/dbbackup/ location? 

Would a PHP script do this? 

Can I make a regular Mysql backup on timestamp?

Finally migrating my files to another database with some issues on a few data. I want to copy arabic words from database but it translates into english letters. How do I copy the data as they are in MY SQL server?

Hi, I deliberated if anyone could help, I have a MySQL database that is hosted on a UNIX server on the internet I wanted to connect to it with Visual FoxPro Vr 8 from a Windows PC. Is this probable, How do I set mysql in VFP to do this ?

Hi,

Is there any possible way to retrieve .mdf files from mySQL server 2000 Database after it went corrupt due to virus infection? Are there any software available to recover missing files?

Thanks,

Ren

Good day,

I am a newbie in web programming and I am coding a registration page. For this, I will just ask the encryption procedure for MySQL.

Thank you so much.