PDA

View Full Version : SQL: Switching servers to Powweb


RobInjection
6-27-05, 03:47 PM
I'm switching servers to POWweb and have a couple of SQL databases that I need to switch as well. I wanted to know, where on the new site do I put these databases?

RTH10260
6-27-05, 04:17 PM
I'm switching servers to POWweb and have a couple of SQL databases that I need to switch as well. I wanted to know, where on the new site do I put these databases?Your package comes with optional 5 databases, you need to define each database in OPS > package > Billing/Plan and the very bottom use the link to define the databases needed. Note: unique name among all Powweb clients.

On page OPS > package > WebSite > MySql you can define up to three usernames per database, again unique among all Powweb clients and separate from ftp/pop accounts. The same name may be shared among your databases. Use the dropdown to switch view between the databases. Note that the mysql server name is listed among all the text.

In phpmyadmin you can signin to the database and import the content as required. Note there is an hourly connect and query count limit per username, you may have to prepare the input file to slip thru. Alternate approach: search this forum for 'mysqldmp' and you should find some instructions on how to ftp upload and the use a script to import from the account.