MySQL databases are in /var/lib/mysql , but I can't seem to find the postgres databases. Anyone know where they are?
Also, do they get transfered over when you move an account from one server to another?
cPanel.net Support Ticket Number:
We tranfered a website from one cpanel server to a new cpanel 7 server. The site is working correctly but the mysql databases and users are not being listed in the "MySQL Database" section in the cpanel page for that site. The databases are in /var/lib/mysql. We no longer have access to the...
Installation went smothly ...
I logged into my client's account and tried to create postgresql database.
Cpanel said it was created, but in the list of databases it is now shown.
So I clicked on the phpPgAdmin link, logged in and tried to create database there.
one of the last updates (I guess to 7.2.1) renamed all mysql databases.
if a user with a hyphaneted username (like 'user-name') created a database in the older cpanel, the database got the name 'username_xyz'.
the update changed it into 'user-name_xyz', which appears logical, but now...
Is this a bug with mySQL or Cpanel?
I had problems a few weeks ago with mySQL databases getting corrupted on my new server at XXX...
Someone helped my diagnose and fix it by adjusting a higher setting for my mySQL connections... from 500 to 5000...
it helped... and the databases quit...
I've upgraded to the latest edge.
When I want to create a new mysql database, that works, but this new database isn't shown in the list.
When I create the same db, I get an error that this database already exists..
Downgrade to mysql 3 and the latest stable fixes that.
My Server Admin has moved the MysQL databases from the default place in /var/
However, an error has occured like this:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in...
We have a client who has the binary data for his site but not the actual exported .sql file. Can any reccomend an easy way to restore this database? It has the FYI AND FRM files and such. I have tried restoring it on Windows and Linux and have been unsuccessful.
Thanks for your time,
I am quite anxious to ensure that our Plesk server Clients transfer to CPanel without problems. Therefore I am trying to have a much setup before we actually begin transferring.
We have some databases that are named with an underscore. Example: name_name
When I set up this type of name...
Databases & mysql
Can WHM do this? Anyone know if its possible?
1. If we create a MySQL database on your server, do we have access to the actual database file so that we can download it off your server? My client will need this database locally to run reports and use for other purposes...
I use PHP + mysql on my website.but I don\'t know how to link my databases.
Warning: Supplied argument is not a valid MySQL-Link resource in /home/belong/public_html/chinese/guest/index.php on line 5