login community faq

Hi all,

I just registered to webfaction using the birthday promo, yay!

Right now I'm moving all my files and database from my previous hosting, dreamhost.

I found out that the database name limitation in webfaction is really limitating.

I'm using donnykurnia as my username, so with underscore, it will leave only 4 character for database name. When I'm registering, I do not see any notes about this, because if I see it, I might choose shorter username.

In dreamhost, I could set the database name longer than 16 character, so I believe this is not the limitation of MySQL.

Could webfaction do something about this?

asked Feb 11 '12 at 09:34

donnykurnia's gravatar image

donnykurnia
31


This is well-requested and the new databases UI that we are working on will get rid of the limitation of having to have the username at the start of your database name.

answered Feb 11 '12 at 09:51

iliasr's gravatar image

iliasr ♦♦
7013

Great to hear that. When will we could get this feature?

(Feb 11 '12 at 23:07) donnykurnia donnykurnia's gravatar image

We don't have an ETA yet, but it should be sooner rather than later.

When we do roll it out, we will announce it on our blog!

(Feb 12 '12 at 02:10) iliasr ♦♦ iliasr's gravatar image

In the meanwhile, it would be a service to new users to indicate where and how their username is used and what it constrains, before they pick a username. I ran into the same issues as donnykurnia.

(Feb 13 '12 at 12:49) cesnn cesnn's gravatar image

Yep, this was really confusing for me too.

(Mar 31 '12 at 02:24) Sumedh Sumedh's gravatar image

It is all about conventions.
If you renounce to descriptive names and categorize your databases by an initial letter and then numbers, you will have almost 24,000 (=24 * 999) name possibilities:
- donnykurnia_a001
- donnykurnia_a002
- ...
- donnykurnia_a999
- donnykurnia_b001
- ...
- donnykurnia_b999
- ...
- donnykurnia_z999

you could also use the first 3 letters in unix style as abbreviations: for example, if you need different customer or user databases, they night be called:

  • donnykurnia_cus1 -> cus9
  • donnykurnia_usr1 -> usr9
  • donnykurnia_etc1 -> etc9
  • and so on...

Regards
Roberto

answered Mar 31 '12 at 05:59

robertotra's gravatar image

robertotra
437

edited Mar 31 '12 at 06:11

Your answer
If you have an answer to the above question, then use the form below. Otherwise, use the appropriate 'add new comment' button above to post your feedback.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×116
×54
×10
×2

Asked: Feb 11 '12 at 09:34

Seen: 628 times

Last updated: Mar 31 '12 at 06:11

Plans & prices    Sign up    Why WebFaction?    Contact us    Affiliate program    Support    Legal    Jobs    Blog    Control panel login
Powered by OSQA
© Copyright 2003-2012 Swarma Limited - WebFaction is a service of Swarma Limited