Baron Schwartz wrote:
Whil Hentzen wrote:
Michael Dykman wrote:
if you see no errors, check your config... are you sure InnoDB is
enabled ?
I can create a new database and add InnoDB tables to it without problems.
Ack, I lied. No error in the /var/lib/mysql, but there IS an error
file in
ething but I sure can't see it...
Whil
On 9/11/07, Whil Hentzen <[EMAIL PROTECTED]> wrote:
Hi gang,
After reading through two years of 'how do I back up my database'
threads, I'm trying out the various backup mechanisms offered up.
I've read through these steps:
Hi gang,
After reading through two years of 'how do I back up my database'
threads, I'm trying out the various backup mechanisms offered up.
I've read through these steps:
http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html
Running a local box and a remote box, both with Fedora 6, MyS
Mine runs with warnings, not errors. it works just fine. However, this
is on CentOS 4.3. I've yet to get MySQL Query Browser to work under
CentOS 4.3, but that's a project for tonight.
Note however that MySQL Administrator and MySQL Query Browser are two
different things.
Oh, yes, I'm awa
Hi folks,
Brand new Fedora Core 5 box running MySQL 5. I can get into the monitor
and connect, work with databases, etc. I can't get the MySQL
Administrator to run - get lots of errors:
1. I downloaded mysql-administrator-1.1.10-1.i386.rpm.
2. As root, in /usr/bin, did
rpm -Uivh /home/zips/m
I'm trying to run the MySQL monitor in a DOS box and having no luck. I
open a DOS box, and no matter what command I run, I do not get the nifty
mysql> prompt that I can get on my Linux machine. Here are some
permutations and the results (or lack thereof):
c:\mysql\bin> mysql -u root -p
mysql:
Hi folks,
I have MySQL 5.0.18 running like a charm on Win2K as a service. I've
been connecting to it willy-nilly, creating databases and querying the
daylights out of it. Working just dandy.
I'm trying to run the MySQL monitor in a DOS box and having no luck. I
open a DOS box, and no matter
I've looked at concat and other string functions as well as searched
on 'update' and 'longtext', but the results haven't been useful. Am I
missing something easy, or will this be more involved than a simple
one-line SQL statement?
You obviously didn't look at CONCAT that hard...
UPDATE mytab
Hi folks,
I'm converting a database to MySQL, and rewriting the code to work with
MySQL from the old datastore.
One of the fields in one of the tables is a longtext type that contains
a history of system accesses - each time the system is touched in one
form or another, a few more lines of t
Gleb Paharenko wrote:
Hello.
Are you sure that you want to load PDF with LOAD DATA INFILE?
Well, I had been sure, but not so much anymore.
Maybe LOAD_FILE is that you want:
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
Yup, this was the ticket. I'd seen several reference
Hi folks,
I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the
following command
LOAD DATA INFILE '1037021.pdf' INTO TABLE complete FIELDS TERMINATED BY
'%%EOF' (d_c)
in the Query Browser 1.1.17, MySQL 5.0.15, running on W2K. Field d_c is
defined as LONGTEXT.
The followi
Elim Qiu wrote:
Here is where i stuck:
I stopped the mysql service, renamed the 5.01 folder(backup), unzip the 5.02
and put it where 5.01 worked.
I'm wondering if there are specific folder names that have "5.02"
instead of "5.01"? Or registry entries?
My version of MySQL doesn't have anything
- SQL command on connect: left empty
Note that I can connect to and manipulate the test database
interactively (I added a table, inserted records, etc., all as user
'whil')
7. Hit "Test Data Source"
8. Error message: [MySQL][ODBC 3.51 Driver] Client does not support
authentication proto
Elim Qiu wrote:
Anyone successfully make MySQL 5.02 working on windows2000?
I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no
success.
I'm running 5.0.2-alpha-net on W2K. Got it running without any problems.
Getting ODBC to work, on the other hand, was a bit of a chore
1. Windows 2K and MySQL 5
2. Downloaded the 3.51.9 driver (I've seen a number of issues reported
with the .10 driver, so avoided it to begin with) and installed it. It
shows up in the ODBC admin nicely.
3. Created a new file DSN with the ODBC Admin
4. After I entered a name for the dsn ("mysqlf")
Hi folks,
Been doing a lot of noodlin' and googlin' yesterday and today, and
thought I found the problem... but alas!
To recap:
I just installed MySQL 5 on a freshly updated FC3 box. I initially was
getting this error:
[EMAIL PROTECTED] ~] /usr/bin/mysqld_safe
Starting mysqld daemon with databa
[EMAIL PROTECTED] wrote:
We need more details in order to help:
What operating system are you on?
Which version of MySQL are you attempting to run?
How are you attempting to start the MySQL server?
Has it worked before or is this a new installation?
What errors are being reported to your error log?
Hi folks,
I've got a Fedora Core 3 box that came with MySQL 3.23.xx, recently
updated to 3.23.58. I wanted to wipe the box clean and install 5.0, but
the Add/Remove Packages (and the manual RPM command) both failed on
multiple dependencies, so I (foolishly?) took matters into my own fat
little
On Sunday 08 August 2004 22:13, Justin French wrote:
> Can someone give me a quick/clear explanation about why you would
> create a table with columns of NULL / NOT NULL?
>
> I clicked around the MySQL manual last night I *think* I know what's
> what, but it'd be great to read one clear paragraph t
On Monday 02 August 2004 22:34, James Weisensee wrote:
> What does your '/etc/hosts' file contain? Sounds like
> it may have the following entry:
>
> 127.0.0.1 localhost.localdomain
>
> change it to:
>
> 127.0.01localhost
Actually, it has
127.0.0.1 localhost.localdomain localhost
On Friday 06 August 2004 19:49, [EMAIL PROTECTED] wrote:
> Greetings... How do I uninstall MySQL under linux (i have Fedora Core 2)...
> i will be installing a new version of it...
>
> I have 3.23 currently and will replace it with 4. Please Help Thanks
I just did this a couple of weeks ago myself
> For certain columns i am completely sold on not using nulls, for others, i
> cant see any conceptual reason to favor either way, so i thought i'd tap
> you all for some insight.
A NULL is the equivalent of saying "I don't know" whereas a 0 means the value
between -1 and 1 and a blank means 'no
Hi folks,
Now that I can connect to my MySQL server using the Unix sockets (e.g.
[EMAIL PROTECTED] ~] mysql -u root
I'm moving on to the next step - connecting via TCP/IP.
Since I don't have physical access to the box (well, I'm just too lazy to walk
down to the basement), I SSH into the box
> When I then ran mysqlshow I only had the test database, not the mysql
> database as the documentation said I should.
>
> I then deleted everything and installed again, and got the same result.
>
> Does this mean the installation has failed ?
When this happens on Linux, it means you're running my
> dear rhino and whil
> thanks for that valuable tip.
> but, dont i have to wory about the repeating id's (are they not
> redundant...) in this table, excuse me if this query looks silly...
>
> PLANT_MOLECULE
> plant_idmolecule_idquantity
> ------
On Monday 02 August 2004 02:39, Denis Geser wrote:
> I am using MySql to store telephone taxes statistics.
> I have 1 table by month with 60'000 rows each.
>
> My problem is that I need some stats for 3 month.
> For example I need to know the total Time(in second) and total Cost
> for each Number o
> --
> molecule_info
> --
> mol_id
> mol_name
> ---
>
> ---
> plant_info
> ---
> plant_id
> plant_name
>
>
> here, i one mol_name is found in more than one plant_name.
> the
> >
> >Ah, it's not part of the mysqld command itself. Got it.
>
> Right. It's a process-control aspect of how the shell itself works.
And it's also rather confusing! *s* I really thought it was just another part
of the command, not a structure like a pipe or a redirector.
Oh, these Windows
> >I've been looking through the doc, the --help file, and the messages in
> > the archives, and I can't find a reference to what this & character
> > _means_.
> >
> The "&" tells bash to fork the process into the background so you get
> your console / xterm back. If you don't use the "&" at the e
> >faild and locked up. I'm hoping it is no. 1 that happened. if so,
> >how do I get a command prompt after I start the server?
>
> Did you end the command with a & character?
I've been looking through the doc, the --help file, and the messages in the
archives, and I can't find a reference to wha
> [EMAIL PROTECTED] doesn't have a password yet. You need to
>mysqladmin -u root password "newpwd"
> where "newpwd" is the password you want for root.
> After setting the password for [EMAIL PROTECTED], you can connect with
>mysql -u root -p
> I'd suggest that [EMAIL PROTECTED] is a bad id
> >
> >Got it. One of those 'had to read and re-read' multiple times things.
> >
> >> If you install using an RPM, the account should be created for you.
> >
> >I've done this now. I ripped out all the old files, did a complete RPM
> > install and up to testing, everything ran fine.
> >
> >In orde
> >I'm reading through the doc (gasp!) on the mysql.com site, specifically,
> > 2.4 Unix Post Installation Procedures:
> >http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html
> >
> >The first sentence in the last paragraph before the numbered steps says:
> >
> >"In the examples shown here,
Hi folks,
Just installed MySQL 4 on my Fedora Core 2 box (that didn't have any mysql on
it initially.) Three questions.
I'm reading through the doc (gasp!) on the mysql.com site, specifically, 2.4
Unix Post Installation Procedures:
http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html
Hi folks,
Installed Fedora Core 2 with mysql and then removed the mysql packages via the
gui widget. Then installed mysql 4 from scratch. Created a symlink, mysql.
added the user 'mysql'. chown'd etc the /usr/local/mysql stuff.
the command (as root)
/usr/local/mysql# bin/safe_mysqld --user=m
35 matches
Mail list logo
