Guest lorph Posted June 12, 2005 Posted June 12, 2005 Hello everyone. CPanel and phpmyAdmin is limited by a maximum file size and/or execution time. If you run into timeouts loading your db, here is what you can do. Login to your CPanel. Under "Access Hosts:" add your external ip address. http://whatismyip.com Download mySQL Control Center and run it. (right now windows and linux only) Connect to your domain with the program. Now you can press the SQL button which lets you load sql files and run them into your database. Quote
TCH-Andy Posted June 12, 2005 Posted June 12, 2005 Hi lorph Welcome to the Forum Thanks for the info. As an alternative, you can simply upload the mySQL file to the server using FTP, then open a ticket at the help desk, and ask us to load it into your database for you. Quote
TweezerMan Posted June 12, 2005 Posted June 12, 2005 Welcome to the forums, lorph! I've used the MySQL Control Center before, but switched to the MySQL Query Browser because of this note on the MySQL web site: Development of MySQLGUI (MySQLCC) has been suspended. Our current development efforts are directed towards the development of MySQL Administrator and MySQL Query Browser. It looks like you can perform this task in MySQL Query Browser too: Click "File", "Open Script..." on the menu, open the .sql file, then click "Execute" on the toolbar. I never thought about doing a MySQL database import that way - pretty neat idea! Quote
Guest lorph Posted June 14, 2005 Posted June 14, 2005 It seems like MySQL AB made another program that was made for backups at http://www.mysql.com/products/administrator/ Quote
Galleon Posted July 3, 2005 Posted July 3, 2005 Well people I tried this and I cannot get it to work. I am trying to connect to my database and administer it from my home machine but not having any success. I would also like to share the information I have on one site with another domain. How do I connect to the database of one domain to another. All my domains are hosted on TCH. Thanks Galleon Brinton Quote
TweezerMan Posted July 3, 2005 Posted July 3, 2005 Galleon contacted me via IM about his problem. He was able to successfully connect to his database once he had the correct port (3306) and the correct database and username (cpanelName_database and cpanelName_username). Welcome to the forums, Galleon! Quote
TCH-Andy Posted July 3, 2005 Posted July 3, 2005 Welcome to the forums, Galleon You will also need to enable remote access in cpanel, if you have not already done so. Quote
dawheels Posted July 10, 2005 Posted July 10, 2005 I just downloaded MySQL Query Browser and I created a database in CPanel and added a user to it. However, I am having trouble using MySQL Query Brower to connect to it. It asks for Server Host, Port, Username, and Password. I am alittle confused what I need to put in the Server Host field and which Username and Password it is asking for (ie. database or CPanel???) Quote
TCH-Andy Posted July 10, 2005 Posted July 10, 2005 Hi dawheels, Welcome to the forum You will need to login to your cpanel first, and in the mysql section, allow access from remote hosts. Then; Sever host: your domain name Port: 3306 Username: the username for your database, usually cpanelusername_user Password: the password for the database Quote
dawheels Posted July 10, 2005 Posted July 10, 2005 Hi dawheels, Welcome to the forum You will need to login to your cpanel first, and in the mysql section, allow access from remote hosts. Then; Sever host: your domain name Port: 3306 Username: the username for your database, usually cpanelusername_user Password: the password for the database <{POST_SNAPBACK}> All i see under mySQl section is add database, user and host. Do I add host to allow access from remote hosts? or am I missing something? Quote
TCH-Andy Posted July 10, 2005 Posted July 10, 2005 Yes, add your IP address in the hosts list (or % for access from anywhere). Quote
dawheels Posted July 10, 2005 Posted July 10, 2005 Yes, add your IP address in the hosts list (or % for access from anywhere). <{POST_SNAPBACK}> IT WORKED! thanks very much for the help! Quote
TCH-Andy Posted July 10, 2005 Posted July 10, 2005 You're welcome That's what the family is here for, I'm glad it's all sorted Quote
dawheels Posted July 11, 2005 Posted July 11, 2005 thanks for the warm Welcome. My brother and I have been using TCH for over a year now. You guys ROCK!!! Quote
ACIDSTEALTH Posted April 2, 2006 Posted April 2, 2006 I'm able to get to the screen where it says 'Restoring (filename)'. But it never starts. Its stuck at 0 bytes. Quote
TCH-Andy Posted April 2, 2006 Posted April 2, 2006 Have you enabled remote access from cpanel, and made sure that your firewall is not blocking port 3306 ? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.