Hi All,
I want to restore mysql database through stored procedure as I am creating
databases at runtime.
Is it possible? Is there any possible workaround for this?
Thanks in advance.
--
Regards,
Manasi Save
Artificial Machines Pvt Ltd.
--
MySQL General Mailing List
For list archives:
hello experts
I am new to mysql. in my server mysql application is installed just like
that. there is no proper driectory strutured maintained.
now my question is. how can i find the datafiles, archive files, backup
location.
i don't have root authentication. is it possible to login to the
Hi!
SQL Maestro Group announces the release of SQL Maestro for MySQL 9.9,
a Windows GUI solution for MySQL administration and database
development.
The new version is immediately available for download at
http://www.sqlmaestro.com/products/mysql/maestro/
New features:
---
If you have a mysql username/password you can start mysql client from the
command line and log in like so
mysql -uusername -ppassword
Where username is your username and password is your password.
Once logged in you can issue the command
Show variables like 'datadir%';
This will tell you
Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to avoid
Hi!
I need to figure out how much disk space an arbitrary number of rows in a table
take up. For example
SELECT DISK_SPACE(*) FROM ORDERS WHERE CREATED_AT BETWEEN x AND y
I know i could do something like a mysqldump with conditions and analyze the
output file but i'd like to avoid
Hi
1. can you please explain me about mysql 5 architecture and background
process..
2. how to create a schema in mysql
3. is there anything like tablespace in oracle..
4. if yes, how to create tablespace.
5. how is storage system in mysql.
in oracle, tablespace-segment-extend-block, is
Hi,
1. can you please explain me about mysql 5 architecture and background
process..
2. how to create a schema in mysql
3. is there anything like tablespace in oracle..
4. if yes, how to create tablespace.
5. how is storage system in mysql.
in oracle, tablespace-segment-extend-block,
hi tonies
no, i don't see this portal before. for my quick view, can u please answer
my question in previous email..
thanks for ur link..
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Wed, Sep 30, 2009 at 3:46 PM, Martijn Tonies m.ton...@upscene.comwrote:
Hi,
Hello Faizal,
no, i don't see this portal before.
You didn't see www.mysql.com before? Geesh...
for my quick view, can u please answer my question in previous email..
I fail to see why I should answer if you don't even bother to look up these
things yourself in about 5 minutes... Is
I think this should work...
SELECT
b.Name AS Boss name,
ad.Name AS Admin name,
as.Name AS Assistant name
FROM Projects AS pr
LEFT JOIN
People AS b
ON b.ID = pr.Boss_ID
LEFT JOIN
People AS ad
ON ad.ID = pr.Admin_ID
LEFT JOIN
People AS as
ON as.ID = pr.Assistant_ID
WHERE pr.Project_ID = 5
I
Basic answers under each of your questions below
-Original Message-
From: F.A.I.Z.A.L sac.fai...@gmail.com
Sent: Wednesday, September 30, 2009 11:11 AM
To: John Daisley j...@butterflysystems.co.uk
Cc: mysql@lists.mysql.com
Subject: Re: iam new bee to mysql
Hi
1. can you please explain
hi tonies..
you mistaken me. I am exploring many forums and discussion. these questions
are only my doubts. iam started to explore mysql.com. but i need some quick
inputs to complete my task. if u or anyone experienced in mysql can answer
this because iam sitting in urgent task.
anyways thanks
hi Daisley
thanks for your answers
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Wed, Sep 30, 2009 at 4:20 PM, John Daisley
j...@butterflysystems.co.ukwrote:
Basic answers under each of your questions below
-Original Message-
From: F.A.I.Z.A.L
On Tue, Sep 29, 2009 at 11:36 PM, mos mo...@fastmail.fm wrote:
Why don't you just say Drop User carlos?
Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user 'carlos'@'localhost';
command. Why can't I
Remove manually (delete) the user from all the privilege tables:
delete from columns_priv where user='carlos';
delete from db where user='carlos';
delete from procs_priv where user='carlos';
delete from tables_priv where user='carlos';
delete from user where user='carlos';
then a nice FLUSH
Carlos Williams wrote:
On Tue, Sep 29, 2009 at 11:36 PM, mos mo...@fastmail.fm wrote:
Why don't you just say Drop User carlos?
Also are you logged in as root?
In my original message to the board I demonstrated the error I get on
my server when I attempt to run the 'drop user
What version of mysql a you using? Drop user works differently for versions
before 5.0.2.
You could just remove the user from the mysql.user table with a delete
statement.
Regards
John Daisley
Mobile +44(0)7812 451238
Email j...@butterflysystems.co.uk
Certified MySQL 5 Database Administrator
Grant
he is trying to login as that user
then drop the user he logged in as
Martin Gainty
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
On Wed, Sep 30, 2009 at 9:12 AM, Martin Gainty mgai...@hotmail.com wrote:
Grant
he is trying to login as that user
then drop the user he logged in as
No, no and no. I clearly showed my commands including my login to
MySQL as root. I also cleanly noted I can't even login as the user I
am
hi Carloswil,
could you do below check:
1. show processlists; // is there any session logined by this user account?
2. select CURRENT_USER() ; // ensure you are logining with r...@localhost, not
the r...@%
best regards
liuyann
Date: Wed, 30 Sep 2009 09:37:28 -0400
Subject:
A very first thing you should do is to evaluate the storage needed by a
single row.
This can be done by summing up all columns data types length in bytes and
index lenght as well.
This should be quite accurate.
Just a tip to start:
Thanks again for assistance. FYI, I did track this thread down
http://ask.metafilter.com/57007/Missing-commas-in-CSV-file
(exerpt:
Maybe there is a space or something in the 14th column of the first 15 rows.
posted by. on February 14, 2007
It's a bug in Excel (not something you did
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this case. I created a database called 'staff' and
then in that database I created one simple table:
mysql show tables;
+-+
|
alter table it add title varchar(50);
Carlos Williams carlosw...@gmail.com escreveu na mensagem
news:d80f793f0909300945n73394480j468c2cf76dc9c...@mail.gmail.com...
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what
Carlos,
Get a free copy of SqlYog (Community edition).
http://code.google.com/p/sqlyog/
Mike
At 11:45 AM 9/30/2009, you wrote:
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this
On Wed, Sep 30, 2009 at 1:11 PM, mos mo...@fastmail.fm wrote:
Carlos,
Get a free copy of SqlYog (Community edition).
http://code.google.com/p/sqlyog/
Thanks but I don't have any GUI's installed on my machine I manage the
database on or from. I am also trying to learn in case things break
If you are very new, you may want to go through the tutorial at w3shools:
http://www.w3schools.com/SQl/default.asp
Regards,
- Robert
On Wed, Sep 30, 2009 at 11:45 AM, Carlos Williams carlosw...@gmail.com wrote:
I am no doubt very new to MySQL and have been studying the on line
manual however
On Wed, Sep 30, 2009 at 8:18 AM, Claudio Nanni claudio.na...@gmail.com wrote:
Remove manually (delete) the user from all the privilege tables:
delete from columns_priv where user='carlos';
delete from db where user='carlos';
delete from procs_priv where user='carlos';
delete from tables_priv
Hi
iam getting the following error while login into mysql server.
andd141# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
Can someone please help me understand why I am not able to login from root?
Best Regards
Faizal S
GSM : 9840118673
Blog:
Use : mysql -u root -p (it will prompt for password) and if its not a local
host also add -h ipaddress
On Thu, Oct 1, 2009 at 11:01 AM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
Hi
iam getting the following error while login into mysql server.
andd141# mysql -u root
ERROR 1045 (28000):
31 matches
Mail list logo