News:

The "Support Requests" forum is now viewable by guests.

Main Menu

Can't login to manage databases on new mysql5.freepgs.com server

Started by podunk, August 25, 2006, 11:54:40 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

podunk

August 25, 2006, 11:54:40 PM
I just created 4 databases on the new mysql5.freepgs.com server, but when I click on the MG link next to them and enter the username and password, the username and password is not accepted and I am denied access. I have checked the username and password carefully and I am definitely entering it correctly. Is there a problem with the mysql5.freepgs.com server? Also, is there any way to create new databases on the old localhost server?

admin

#1
August 27, 2006, 04:48:50 PM
This has been corrected.  (You will need to recreate the databases)

Thank you,
FreePgs.com Admin

podunk

#2
August 28, 2006, 02:34:27 AM
Thank you - it works now. Is there any way to create databases on the old localhost server?

admin

#3
August 28, 2006, 06:39:43 PM
No, all new databases will be created on the remote database server.  As more users move their databases over to the new server, the performance will increase on this system.

Thank you,
FreePgs.com Admin

podunk

#4
August 28, 2006, 11:26:44 PM
I see. I have a lot of databases on the old localhost server and now some on the new server - I would prefer them all to run on the same server. Is there a simple way to transfer all my databases on the old server to the new server (without stuffing them up)?

admin

#5
August 29, 2006, 01:31:34 PM Last Edit: August 29, 2006, 01:33:10 PM by admin
You will need to dump each of the databases, and recreate them on the new server.

You really should consider using less databases.  (Using multiple tables in each database).  You currently have 113 databases.

Thank you,
FreePgs.com Admin

podunk

#6
August 29, 2006, 11:37:28 PM
Each of the databases is for a different project, so all are required. I will dump them when I have some time one day so they all run on the new server. Cheers.

Evilsprouts

#7
August 30, 2006, 06:48:16 PM
113 databases wow no wonder the server is running slow, sort it out man.

dest

#8
August 30, 2006, 07:42:46 PM
Quote from: podunk on August 29, 2006, 11:37:28 PM
Each of the databases is for a different project, so all are required. I will dump them when I have some time one day so they all run on the new server. Cheers.

Ever heard of table prefixes?  You could have one database with 113 different prefixes
meh :P

podunk

#9
August 30, 2006, 11:35:43 PM
Quote from: Evilsprouts on August 30, 2006, 06:48:16 PM
113 databases wow no wonder the server is running slow, sort it out man.

Can't see how having multiple databases slows the server... if I had one database with a thousand tables being hit hundreds of times it's the same amount of traffic as a hundred databases being hit once, isn't it?

podunk

#10
August 30, 2006, 11:37:03 PM
Quote from: dest on August 30, 2006, 07:42:46 PM
Quote from: podunk on August 29, 2006, 11:37:28 PM
Each of the databases is for a different project, so all are required. I will dump them when I have some time one day so they all run on the new server. Cheers.

Ever heard of table prefixes?  You could have one database with 113 different prefixes

With different usernames and passwords for each prefix?

admin

#11
August 31, 2006, 10:12:02 PM
The more databases that exist on a server, the more directories are in the database data directory itself.

Other than that, it does not cause a direct performance problem.  After a certain number of directories, fetching directory information becomes slower (for operations like "SHOW DATABASES")

This should be less of an issue with the new dedicated database server as it is not sharing the file system with other applications.

Thank you,
FreePgs.com Admin
Print
Go Up Pages1
User actions