-1
votes
1answer
47 views

How to find a database location on server using phpmyadmin?

I am pretty new to managing servers, right now I have trouble to find the location of our database. I see the DB in phpmyadmin, is there a way to find the real location using phpmyadmin ? Running ...
0
votes
2answers
97 views

Will re-installing phpmyadmin will have any effect on my Databases?

I am quiete new and somehow I crashed my phpmyadmin website, it can't be displayed without errors after changing the port of it once. So does it has any effect on my databases when I reinstall my ...
0
votes
1answer
36 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 ...
0
votes
0answers
77 views

Strange CPU cycles and slow queries

My database (XAMPP) runs at almost 350 questions a second is 99% in the SELECT category. The website I'm running is heave on timed ajax calls that refresh data every 10 seconds. During this, there are ...
0
votes
2answers
764 views

How do I get my ubuntu server to listen for database connections?

I am having a problems connecting to my database outside of phpmyadmin. Im pretty sure this is because my server isn't listening on port 3306. When I type: sudo netstat -ntlp on my OTHER working ...
0
votes
0answers
104 views

Mysql database on ubuntu server not accepting connections

I am having problems with my database. The only way I can connect to it is via phpmyadmin. I try to use the same username and password to connect to the database in 'SQL PRO' and I get the following ...
1
vote
2answers
1k views

PhpMyAdmin Missing parameter:

Everything was working fine until this moment I want to create a new database and I'm receiving this error db_create.php: Missing parameter: new_db (FAQ 2.8) Also when I was trying to export my ...
0
votes
1answer
272 views

Receiving an error when moving table from one server to the other

I am trying to move a Wordpress table from my old server to my new one and I am receiving this error: SQL query: -- -- Database: `username_film` -- -- ...
3
votes
2answers
1k views

Transfer database data from xampp on Windows to Ubuntu [closed]

Which is the fastest way to transfer mysql databases from xampp on Windows to a MySql server on Ubuntu?
2
votes
0answers
104 views

lost tables in drupal site database

i have drupal site on my local server build using pressflow i had problems with the xammp 1.7.4 server so i delete it except the mysql and htdocs folders i installed the server again but the drupal ...
2
votes
1answer
64 views

How to Properly Migrate SQL

If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server. I notice that in this process, ...
5
votes
2answers
4k views

What is the difference between Replication and Synchronization?

In phpMyAdmin there is a tab for configuring Replication and one for Synchronization. What is the difference between Replication and Synchronization? When do you should use the one or the other? ...
1
vote
2answers
240 views

Database Connection Error

Recently this has been happening every so often...say once a day for about 10 minutes. All the pages on my website load up as a blank page with big text DATABASE CONNECTION ERROR. I try to login to ...
1
vote
1answer
2k views

How can I show column data in PhpMyAdmin on insert?

When I insert a record with a foreign key relationship, how can I change the drop-down to show another foreign table column? By default, it shows the foreign table's primary key (an int) that isn't ...
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 ...
0
votes
2answers
1k views

How should I copy the “mysql” database to my new server using PHPMyAdmin

My new webhosting company has set up a MySQL database for me and it has the tables MySQL and Information_schema already there. I want to copy my existing database from another server (a) to the new ...
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 ...