- Original Message -
> From: "Reindl Harald"
> Subject: Re: When to create a new database
>
> it makes zero sense since you can use different users for the same
> database down to table and even column permissions
No, it does make some sense in the case whe
- Original Message -
> From: "Ron Piggott"
> Subject: Re: When to create a new database
>
> I would lean towards keeping it all together because of the speed
> decrease between connecting to different databases.
Heh, that consideration is a matter of semantics,
On 10/10/2015 10:28 AM, Richard Reina wrote:
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a separate
database
When I read the OP I was thinking: This is one for Reindl. And here we
go.
When dealing with data of this specific kind, you most definitely
would want a date reference. A very small computer will be able to
handle
mane years of all kinds of weird sports statistics.
You need to define the goa
I would lean towards keeping it all together because of the speed
decrease between connecting to different databases.
What I would tend to do is put some type of prefix that would keep the
sets of tables together --- like
lib_sports
lib_rules
lib_statistical
lib_definitions
data_players
da
Am 10.10.2015 um 16:28 schrieb Richard Reina:
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a separate
database
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a separate
database called "library" since they are used for referen
Hello.
See:
http://dev.mysql.com/doc/mysql/en/moving.html
"Andy Hall" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have tried the following process in order to try and replicate a database
> with InnoDB files:
>
> 1. created a new database in PHPMyAd
On Mar 18, 2005, at 7:06 AM, Andy Hall wrote:
Hi,
I have tried the following process in order to try and replicate a
database
with InnoDB files:
1. created a new database in PHPMyAdmin
2. via command line, copied all the .frm files from the old database
directory into the new database directory
"Andy Hall" <[EMAIL PROTECTED]> wrote on 18/03/2005 12:06:30:
> Hi,
>
> I have tried the following process in order to try and replicate a
database
> with InnoDB files:
>
> 1. created a new database in PHPMyAdmin
> 2. via command line, copied all
Hi,
I have tried the following process in order to try and replicate a database
with InnoDB files:
1. created a new database in PHPMyAdmin
2. via command line, copied all the .frm files from the old database
directory into the new database directory
3. changed all the ownership and permissions
4
I could write the statement for you if you could answer these three
things:
1) which user account would you like to modify the permissions of.
2) which database are you granting access to
3) what permissions do you want the user account of 1) to have on the
database of 2)
Respectfully,
Shawn Gr
If you do not use the GRANT, REVOKE, and DROP USER statements to create
and destroy user accounts, you must manually FLUSH PRIVILEGES. It's all
documented in the manual:
http://dev.mysql.com/doc/mysql/en/GRANT.html
and in even more detail here:
http://dev.mysql.com/doc/mysql/en/User_Account_M
Hi, all:
I use root login to create a new databse in the existing server.
Then I use the existing user name in the mysql user table as user name,
add the database and username .. info into mysql db table. Then
mysqladmin to load the table. When I login the database using the
existing user name
What I have here is a database-driven website. In the past, I created a
database and grant privileges to it. Now, I'm creating a carbon copy of
it into another website which will be a test website with a test
database. So, when I try the grant privileges to the test database, it
returned a zero
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Lefty --
...and then BGLefty said...
%
%
% Is there a simple php script out there somewhere (or an example of how to do
It's a little bigger than "simple", but have you seen phpMyAdmin?
% it) to create a new database, username
: Thursday, March 18, 2004 9:45 PM
Subject: Re: php script for new database and user
>
>
>
>
> Hi,
>
> > -Original Message-
> > From: Elly Wisata [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, March 18, 2004 1:55 AM
> > To: [EMAIL PROTECTED]
&
Hi,
> -Original Message-
> From: Elly Wisata [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 18, 2004 1:55 AM
> To: [EMAIL PROTECTED]
> Cc: 'BGLefty'
> Subject: RE: php script for new database and user
>
> I don't think php script can create da
Hi,
> -Original Message-
> From: Elly Wisata [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 18, 2004 1:55 AM
> To: [EMAIL PROTECTED]
> Cc: 'BGLefty'
> Subject: RE: php script for new database and user
>
> I don't think php script can create da
: Thursday, March 18, 2004 1:55 AM
To: [EMAIL PROTECTED]
Cc: 'BGLefty'
Subject: RE: php script for new database and user
I don't think php script can create database. But maybe I am wrong. If I am,
please somebody make it straight.
Create a database should do it through console or some kind
PM
To: [EMAIL PROTECTED]
Cc: BGLefty
Subject: Re: php script for new database and user
At 11:45 3/17/2004, BGLefty wrote:
>
>Is there a simple php script out there somewhere (or an example of how to
do
>it) to create a new database, username and password? I would like to have a
>f
At 11:45 3/17/2004, BGLefty wrote:
>
>Is there a simple php script out there somewhere (or an example of how to do
>it) to create a new database, username and password? I would like to have a
>form in a password protected folder on my web site and be able to fill in
>those thr
Is there a simple php script out there somewhere (or an example of how to do
it) to create a new database, username and password? I would like to have a
form in a password protected folder on my web site and be able to fill in
those three variables to create a new database on my installation of
I am setting up a new database with MySQL for the following purposes:
1. Enter information for potential employees like name address email
address employment status, resume, and some more.
2. I am looking to develop build or use something allready developed as
a gui interface to allow users to
Hello,
I am new to My-SQL... and I have installed MySql under Windows 2000 SP3. I
am using WinMySQL 1.4 for administration but I am not able to get the
option to add a new database when everything seems to be working alright (
no errors in the err file)
Version of MySQL: 3.23.55-max-nt
OS
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: "RBE" <[EMAIL PROTECTED]>
To: "Peter Grigor" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 1:09 PM
Subject: Re: New Database,
> -BEGIN PGP SIGNED MESSAGE---
can return to the list.
good luck,
henning
p.s.: please keep the discussion on the list
Richard Nagle wrote, On 2/14/2003 5:24 PM:
in the simplest form,
how to create a new database.
how to assign users to that database.
how to create tables...etc etc
was looking for a more a layman
>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 10:57 AM
Subject: New Database,
> Okay,
> I have installed, mySQL, ( all is well )
> and now looking to build my first database,
>
> is there a comprehensive user manual on how to,
> s
On Friday 14 February 2003 17:57, Richard Nagle wrote:
> I have installed, mySQL, ( all is well )
> and now looking to build my first database,
>
> is there a comprehensive user manual on how to,
> say in .pdf format out there ?
>
> if not, a on-line link maybe ?
Please, check the following link:
Richard,
what exactly do you mean?
guidelines to good database engineering? which data how an where to
store? intelligent table structures?
or technical instructions related to mysql? -> documentation, see
message attachment
cherio,
henning
Richard Nagle wrote, On 2/14/2003 4:57 PM:
Okay,
Its a lot easier asking people than trying to look for yourself isn't it?
Well, that is frowned uppon over here. You should ask us questions when
you have attempted to find the solution yourself first.
http://www.mysql.com
click on the documentation link on the header.
See, it wasn't so hard!
- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 10:57 AM
Subject: New Database,
> Okay,
> I have installed, mySQL, ( all is well )
> and now looking t
Yes, there are, many :)
Jerry
- Original Message -
From: "Richard Nagle" <[EMAIL PROTECTED]>
To: "list - MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 14, 2003 3:57 PM
Subject: New Database,
> Okay,
> I have installed, mySQL, ( all is well
Okay,
I have installed, mySQL, ( all is well )
and now looking to build my first database,
is there a comprehensive user manual on how to,
say in .pdf format out there ?
if not, a on-line link maybe ?
Thanks-
Richard
-
Before
Admin.
Regards, Bjorn
>I am relatively new to mySQL. I have just installed mySQL from source on
>a local FreeBSD server. bin/mysql_install_db installed the mysql and test
>databases. I can verify this on the server and with phpMyAdmin from my
>Mac. Now when I create a new database I c
I am relatively new to mySQL. I have just installed mySQL from source on
a local FreeBSD server. bin/mysql_install_db installed the mysql and test
databases. I can verify this on the server and with phpMyAdmin from my
Mac. Now when I create a new database I can verify that it exists like so
ving the info to it.
But I am having a lot of problems creating a new database in MySQL. OK, here
we go...
When I hit the MySQL-Front Icon, I get the "Connection to MySQL-Host". Now I
click on the "New" button. I get the description screen, I type in the name
of the n
I copy this new database over? Do I need to load it or can I
DC> copy it as is into a directory.
If it's a dump file you should create database with mysqladmin or
using CREATE DATABASE statement:
http://www.mysql.com/doc/m/y/mysqladmin.html
http://www.mysql.com/doc/C/R/CREAT
ROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 11:45 PM
Subject: Newbie: How do I copy over a new database?
> Please forgive this easy question from a newbie:
>
> I was given a MySQL database file from a client with a .sql extension. I
> alre
Please forgive this easy question from a newbie:
I was given a MySQL database file from a client with a .sql extension. I
already have several databases setup and running under MySQL on our server.
But how would I copy this new database over? Do I need to load it or can I
copy it as is into a
PR,
Monday, May 13, 2002, 8:28:20 PM, you wrote:
P> Thnaks . I tried several variation and they are giving me sql syntax
P> error:
:) mysqldump is not an SQL command, it's a program for database backup.
So, you should run it from DOS prompt, f.e. if MySQL is located in
C:\mysql, it would be:
-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 11:32 AM
To: [EMAIL PROTECTED]
Subject: Re: Backing up/Creating new database
PR,
Monday, May 13, 2002, 5:47:23 PM, you wrote:
P> I have database developed on my laptop. What is the quickest way to
P> backup the
over.
Want to change the name of the database? Change the name of the
subdirectory.
-Rob
-Original Message-
From: PR [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 7:47 AM
To: [EMAIL PROTECTED]
Subject: Backing up/Creating new database
Hi,
I have database developed on my laptop
PR,
Monday, May 13, 2002, 5:47:23 PM, you wrote:
P> I have database developed on my laptop. What is the quickest way to
P> backup the database and restore it on the server? Can I restore the
P> database as empty database? Howa bout creating SQL statements based on
P> the database structure?
mysq
Hi,
I have database developed on my laptop. What is the quickest way to
backup the database and restore it on the server? Can I restore the
database as empty database? Howa bout creating SQL statements based on
the database structure?
Thanks
--
Go to http://www.mysql.com/doc/ and read through it. Pay very close attention to
http://www.mysql.com/doc/U/s/User_Account_Management.html the answere to your question
is in there.
Cheers
M;)
-Original Message-
FROM: jean.schuller
TO: Liste mysql
DATE: Fri 9/14/01 8:12
SUBJECT: New
there is no password yet. so leave the -p option out.
jean.schuller wrote:
> Hi all,
>
> I installed a new linux Red Had version onto a PC.
> In this Linux, mysql(version 3.23.39) is already installed
> and mysqld is running. So I want to build a database
> with m
At 03:58 PM 9/14/01 +0200, jean.schuller wrote:
> I'm under root and say :mysql -u root -p password and
> mysql says ERROR 1045: Access denied for user: 'root@localhost'
>(Using password: YES)
> What can this password be ?? where can I get it ??
Did you set a password with
Hi all,
I installed a new linux Red Had version onto a PC.
In this Linux, mysql(version 3.23.39) is already installed
and mysqld is running. So I want to build a database
with mysql but whatever I try to type, I have systematically
errors messages
49 matches
Mail list logo