PDA

View Full Version : Accessing SQL through MySQLcc


SE|nota
7-13-04, 04:43 PM
Hello, I've recently just switched to powweb (yesterday), and I've been wondering if I could access the db through MySQLcc (found on the mysql.com site). I know phpMyAdmin is an excellent tool, but I'd like this as an option aswell.

As far as I know, I have all the info correct:

host: mysql06.powweb.com
usrname: -samething I use on MyAdmin
pw: - again, same
port: 3306


However, if I use that I recieve the following error:
ERROR 2003: Can't connect to server on 'mysql06.powweb.com' (10060)


Is there per chance an extension to the user name if you arent loggin in through powweb, or is this just disabled? If so, is there a way I can get in enabled?


____________

I've also found that I can't upload a 3mb+ .sql backup through phpMyAdmin. Do I need to cut this down or find an alternative?

---
Thanks in advance

tbonekkt
7-13-04, 04:49 PM
No you can't use mysqlcc. PowWeb disabled remote connections to the mysql servers last year to maintain the integrity of the servers. The result has been extremely reliable service.

HalfaBee
7-13-04, 08:45 PM
You will have to split your backup into smaller peices.
2mb is the upload limit.
If you have a look in the sticky thread, I wrote a little script to do biggish restores.
You will have to FTP your backup to the server first.

SE|nota
7-14-04, 02:36 PM
Thanks, I'll try that and see how it goes.

[edit]
I actually couldn't see the page when I u/l it (even though I could on my laptop), so I broke it up manually. Now, while connecting through php I get:
Connect Error: Table 'uselite.root_news' doesn't exist

Even though that is both the db name and tablename.