Web Hosting Talk







View Full Version : MySql - cn't create database


fsenecal
07-08-2001, 05:27 PM
Hi all !

I am new to Cobalt Raq4.

i have installed MySql v3.23.37 with a packahe downloaded form http://pkg.nl.cobalt.com
and the install is successfull ;)

Root password changed succesfully.

But, i cannot create database. When i try to create a database i always get the following error message:
I cannot create database, i always get an error : Can't create database <mynewdb> (Errno: 122)

Anyone can help me with this ???

I also have a notice from the server:
saying "mysql is close to or over quota"
with detail:
"mysql is very near or over the disk space limit allocated on the Cobalt server.
Once the quota limit is reached, no more data can be stored. Consider moving
some data to another location or increasing the limit.
Quota Limit: 0.02 MB
Quota Used: 0.07 MB
Percent Used: 345 %"

How I can change this ???

Thank you and have a nice day
Fernand Senecal

jks
07-08-2001, 05:58 PM
Originally posted by fsenecal
But, i cannot create database. When i try to create a database i always get the following error message:
I cannot create database, i always get an error : Can't create database <mynewdb> (Errno: 122)

You gave the reason yourself later in the post :-)

Errno 122 = Disk Quota Exceeded

So you need to allow the user more disk space - or remove the user from the quota system.

Use edquota to control the quota allowance, if you haven't set mysql up as a user in the GUI.

--
Jens Kristian Søgaard, Mermaid Consulting I/S,
jens@mermaidconsulting.dk,
http://www.mermaidconsulting.com/
http://www.raqsupport.net/

fsenecal
07-08-2001, 06:33 PM
Thank a lot...

Now, i know what mean errno 122 :)

I have installed MySql using default installation.

So I don't know if MySql is set as a user.

Where can i have more info on how to use edquota ?

Thank a lot :)

jks
07-08-2001, 06:34 PM
Originally posted by fsenecal
Thank a lot...

Now, i know what mean errno 122 :)

I have installed MySql using default installation.

So I don't know if MySql is set as a user.

Where can i have more info on how to use edquota ?

Thank a lot :)

Try running:

man edquota

It displays the manual.

Remember that you can do an:

export EDITOR=emacs

To use your favorite editor :-)

--
Jens Kristian Søgaard, Mermaid Consulting I/S,
jens@mermaidconsulting.dk,
http://www.mermaidconsulting.com/

fsenecal
07-08-2001, 07:56 PM
Thank Jens !

My MySql is now working :)

As a bonus...I my control panel...the Active Monitor led have stop splahing :D

Thank a lot :)

RAQ4 come with Perl 5.00503 which is now obsolete.
Do you know a save way to upgrade to Perl 5.6 ??

I am totally new to RAQ4 and effraid to crash things.

I have checked and cannot find a .pks to upgrade my Perl.

seeya
Fern

jks
07-08-2001, 08:00 PM
Originally posted by fsenecal
Thank Jens !
RAQ4 come with Perl 5.00503 which is now obsolete.
Do you know a save way to upgrade to Perl 5.6 ??


Well, the (unmodified) GUI will not run with Perl 5.6.

The easiest thing is to install Perl 5.6 in a different directory than the one with the old perl (i.e. use a prefix).

--
Jens Kristian Søgaard, Mermaid Consulting I/S,
jens@mermaidconsulting.dk,
http://www.mermaidconsulting.com/

fsenecal
07-08-2001, 08:07 PM
Hi Jens,

Thank you for all :)