WebFaction
Community site: login 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 11 Feb '12, 09:34

donnykurnia's gravatar image

donnykurnia
312
accept rate: 0%


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.

permanent link

answered 11 Feb '12, 09:51

iliasr's gravatar image

iliasr ♦♦
1.6k4
accept rate: 36%

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

(11 Feb '12, 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!

(12 Feb '12, 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.

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

Yep, this was really confusing for me too.

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

It has been over a year, any update on the ETA of the change?

(03 Apr '14, 20:15) davideves davideves's gravatar image

The change was announced January 10, 2013 in our blog (http://blog.webfaction.com/2013/01/new-databases-management-interface/)

(03 Apr '14, 20:19) maryh ♦♦ maryh's gravatar image

Thanks for the reply. I looked at the video. My Dashboard does not look the same and when I created a new database it is created using the "accountname with underscore" prefix.

How do I start using the "new" UI/Control Panel?

(08 May '14, 21:21) davideves davideves's gravatar image

You don't need to do anything to start using the new panel - it's live for all of our customers at this time. What you see in that video is actually an older version of the panel.

The current panel does not suggest any default naming scheme when you create a new database, but databases that are created automatically by our application installers will still use the "accountname_dbname" scheme.

(08 May '14, 21:36) seanf ♦♦ seanf's gravatar image

Is there any chance of changing the application installers to allow you to name the database when installing it?

(29 Mar, 12:43) mawebfaction mawebfaction's gravatar image

Our current installer system doesn't allow for that specifically.

However, if you want to write your own installer, you could use the "extra info" parameter for that purpose.

(29 Mar, 18:23) seanf ♦♦ seanf's gravatar image
showing 5 of 10 show 5 more comments

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

permanent link

answered 31 Mar '12, 05:59

robertotra's gravatar image

robertotra
572919
accept rate: 0%

edited 31 Mar '12, 06:11

Your answer
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

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×164
×83
×14
×2

question asked: 11 Feb '12, 09:34

question was seen: 3,548 times

last updated: 29 Mar, 18:23

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2016 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM