, even if a bit more work to
setup, sometimes.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
client. The -t tells SSH to allocate a pseudoterminal even though
you specified a command to run.
Now, that sounds like a plan!
-thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
to run against the db,
but I suppose there's always something.
Yes, I'm still figuring out the mechanics of ssh. It was more of a ssh
question than a MySQL question, fair enough, pardon about that, but was
within the specific context of MySQL.
-Thufir
--
MySQL General Mailing List
For list
On Sun, 08 Mar 2015 13:41:32 +0100, Reindl Harald wrote:
What's the advantage?
that you can have a local application using mysql by -h 127.0.0.1 which
is a complete different thing than a interactive shell?
Thank you for explaining that.
-Thufir
--
MySQL General Mailing List
For list
On Sun, 08 Mar 2015 08:43:41 -0400, Ruben Safir wrote:
gmail sucks
You prefer yahoo mail? Just curious.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Sun, 08 Mar 2015 10:47:17 +0100, Reindl Harald wrote:
oh my god... https://www.google.at/search?q=ssh+tunnel
hmm, are you thinking that I'm not using ssh? Because I'm using ssh
currently, and it works fine.
How is ssh -L 3305:localhost:3306 thufir@192.168.1.3 any better
On Sun, 08 Mar 2015 00:20:26 +, Thufir wrote:
I mean, I can ssh into tleilax and then fire up the MySQL console. Is
there a better approach?
This just hangs:
thufir@doge:~$
thufir@doge:~$ mysql -u cron -h 192.168.1.3 -p
Enter password:
^C
thufir@doge:~$
because, I think, I
I want to ssh into Mysql, something like:
thufir@doge:~$
thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3
bind: Address already in use
Last login: Sat Mar 7 19:18:20 2015 from 192.168.1.2
Thank you for installing ViciBox Server v.6.0!
This software is available for free download
On Sun, 08 Mar 2015 01:30:46 +0100, Reindl Harald wrote:
Am 08.03.2015 um 01:20 schrieb Thufir:
I want to ssh into Mysql, something like:
thufir@doge:~$
thufir@doge:~$ ssh -L 3306:localhost:3306 thufir@192.168.1.3 bind:
Address already in use
that is a pretty clear message
you can't
all to a specific user, make sure to use the
%, which, I think, allows remote connections.
HTH,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
when you run a .sql file, which modifies a schema, is it transactional?
Specifically, is it an all-or-nothing proposition? Or, can some commands
get executed, some fail?
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
, then occasionally save an interesting one to a mail
folder or reply and take part to a thread.
Someday, in the far, far future, someone will re-invent usenet.
Until then, there's gmane!
although a surprising number of mailing lists have some sort of mistrust
towards gmane.
-Thufir
--
MySQL
leery about messing up the Windows system, just want to clarify.
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Tue, 18 Nov 2014 13:09:25 +, Daniel Rios Couto wrote:
You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large
text...
On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald h.rei...@thelounge.net
wrote:
Am 18.11.2014 um 10:48 schrieb thufir:
I'm trying to store a web page
-18 01:36:57.574--ServerSession(17148489)--
EclipseLink, version: Eclipse Persistence Services -
2.5.2.v20140319-9ad6abd
[java] [EL Info]: connection: 2014-11-18 01:36:58.798--ServerSession
(17148489)--file:/home/thufir/NetBeansProjects/AggregatorJpaClient/build/
classes/_SeleniumIteratorPU
||
+-+--+--+-+-++
5 rows in set (0.00 sec)
mysql
While I know that I should alter the table, I don't know the syntax to
establish the foreign key constraint.
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http
On 14-11-17 01:42 AM, thufir wrote:
Looking at the docs:
http://dev.mysql.com/doc/refman/5.6/en/create-table-foreign-keys.html
how do I alter the child table, links, so that it has a foreign key with
the parent table, feeds?
The workbench GUI came up with:
ALTER TABLE `rome_aggregator
`UNQ_links_0` (`link`),
KEY `fk_links_1_idx` (`feed_id`),
CONSTRAINT `fk_links_1` FOREIGN KEY (`feed_id`) REFERENCES `feeds`
(`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=270 DEFAULT CHARSET=latin1 |
I'll be reading a bit more about this.
thanks,
Thufir
--
MySQL
I followed the manpage for mysqlimport:
thufir@dur:~$
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test
ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using
password: NO)
thufir@dur:~$
thufir@dur:~$
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT
I think it's apparmor:
thufir@dur:/tmp$
thufir@dur:/tmp$ nl /etc/apparmor.d/usr.sbin.mysqld
1 # vim:syntax=apparmor
2 # Last Modified: Tue Jun 19 17:37:30 2007
3 #include tunables/global
4 /usr/sbin/mysqld {
5#include abstractions/base
6#include
Apparently this error is because MySQL can't read my home directory?
Fair enough, but I don't quite follow. Where would be a good location
for the CSV file, then?
thufir@dur:~$
thufir@dur:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g
On Mon, 23 Jun 2014 10:59:48 -0400, Scott Helms wrote:
I generally drop them into /tmp for easy access and cleanup after the
data load, but you can put them any place that the mysql daemon process
has access to read.
Huh, maybe the daemon doesn't have access to /tmp?...
thufir@dur:/tmp
text. Should the content be in its own table?
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
this is not the case and the list is read-only on gmane. Would it be
possible to change that?
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
to represent that the break wasn't at the
correct time? A metric?
I'm thinking that the schedule would be its own table, and then an
events table to store login/logouts, breaks and meal breaks. Would it
make sense for the PK of both tables to be the employee ID number?
thanks,
Thufir
On Thu, 06 Mar 2008 08:05:06 -0800, puntapari wrote:
And returning a list of numbers? It can be and how?
A bit tangential, but this calculation could be done recursively with
ruby. Are you tied to SQL for this?
-Thufir
--
MySQL General Mailing List
For list archives: http
of:
SELECT * FROM database.schema.table;
Obviously, this is non-sense in MySQL, where database == schema.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
info people have to offer.
Would this be like an ldap server?
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
into MySQL as the root db admin but can't add the
rails MySQL user so that user thufir can login to MySQL as rails
passing the password from /etc/my.cnf (too many pronouns for that to make
sense).
Some success:
[EMAIL PROTECTED] ~ $
[EMAIL PROTECTED] ~ $
[EMAIL PROTECTED] ~ $ mysql -u root
.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
object name is
server.database.schema.object.
In your two examples:
SELECT * FROM server.sales.schema.product;
SELECT * FROM server.product.schema.product;
I'm a bit tired, so maybe I'm not seeing it, but what goes in the schema
place holder?
-Thufir
--
MySQL General Mailing List
For list
queries! when I asked what the primary key was
going to be for the new table(s) he mentioned that when the db was
initially designed that they didn't know about primary keys! As if PK's
are a fad...
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Wed, 05 Mar 2008 09:29:03 +0100, Sebastian Mendel wrote:
SELECT
comments.content,
SUM(votes.votes)
FROM
comments
LEFT JOIN
votes
ON
comments.id = votes.comment_id
GROUP BY
comments.id
Interesting :)
-Thufir
--
MySQL General Mailing List
For list
On Wed, 05 Mar 2008 15:01:12 +0100, Joerg Bruehe wrote:
I have not heard of a three level naming scheme yet.
Aha, thanks for the history, helps to put what I was reading into context.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
I've
been doing it. Some databases do it differently, apparently.
Apparently MySQL lacks this feature, but what feature is it lacking?
There's no equivalent to:
SELECT * FROM database.schema.table;
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
you have fifty plus tables with, apparently, the same
schema? Why not have one table with an extra column user?
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I understand that there's a configuration so that instead of typing:
[EMAIL PROTECTED] ~ $ mysql -u root -ppassword
that the password (of password) is stored so that whenever this user
connects as root the password is automatically passed.
Is this possible?
thanks,
Thufir
--
MySQL
#Databases_vs_Schemas_.28terminology.29
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or correct,
please?
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* FROM ReachableFrom
WHERE Source = Portland;
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/
it wouldn't make sense in a cost/benefit analysis. Just curious what
others think of this program.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to do with the mysql password or the spaces in the file.
I changed the SQL syntax, but will test it further as I'm getting back
into MySQL :)
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
was
wondering was: what's the value of this certification for me? What
doors will it open?
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
with it, IMO.
[...]
Yeah, I think that I'm going for the certification, although I can't
imagine what kind of job I could land -- junior DB admin? I don't
have a college degree :(
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
fields.
http://www.plus2net.com/sql_tutorial/sql_linking_table.php
how is this different/better than a many-to-many, such as
http://www.plus2net.com/sql_tutorial/sql_inner_join.php? Isn't that
a better way of doing the same thing? Or, not?
thanks,
Thufir
--
MySQL General Mailing List
For list
I want contacts to have a 1-1 relation to px_items. I'm hesitant to add the
contact info onto px_items because http://www.feedonfeeds.com/ uses that
table.
from phpMyAdmin, how would I re-organize things pls? Or, must I manually enter
the SQL to establish the foreign key part?
Once I have
I'll be using http://rss2email.infogami.com/ for saving rss info.
Just curious as to how others would do this, to avoid data entry.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, C1
A2, B2, C2
A3, B3, C3
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ ll /tmp/abc.txt
-rw-r--r-- 1 thufir thufir 33 Apr 12 06:59 /tmp/abc.txt
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ date
Fri Apr 13 08:33:44 BST 2007
[EMAIL
explain *why* this worked and all my other attempts
didn't? Was it because of file permissions? or the linux user id? or that I
put a passwork on the mysql root account? or that I changed the ownership of the
data file? or that I took out some spaces on the data file? Or, ... ?
-Thufir
what would be the quickest, easiest way to import, for example, the rss feed
http://rss.gmane.org/gmane.comp.db.mysql.general into mysql?
what would be some different approaches, pls? I'm more interested in craigslist
stuff, but the above is a good example, I think.
thanks,
Thufir
--
MySQL
Ryan Stille ryan at cfwebtools.com writes:
Perl would be my language of choice to do something like this.
-Ryan
what about http://paperboy.sourceforge.net/?
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I'm at total loss. apparently, error 13 relates to file permissions? what
could possibly be preventing the import?
http://paste.husk.org/8073 for:
[EMAIL PROTECTED] ~]$
[EMAIL PROTECTED] ~]$ ll /tmp/abc.txt
-rw-r--r-- 1 thufir thufir 33 Apr 12 06:59 /tmp/abc.txt
[EMAIL PROTECTED] ~]$ cat
I'd like to import an RSS feed into mysql using
http://paperboy.sourceforge.net/
and was curious as to whether others have done similarly.
thanks,
Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
| NO | | | |
| c | text | NO | | | |
+---+--+--+-+-+---+
3 rows in set (0.01 sec)
mysql LOAD DATA INFILE '/home/thufir/abc.txt' INTO TABLE delta.abc;
ERROR 13 (HY000): Can't get stat of '/home/thufir/abc.txt' (Errcode: 13)
mysql
, this is the scenario. I'm just curious as to what could cause
such a situation.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to the library first chance I can.
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
'\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED] ~]# date
Wed Feb 1 03:48:43 EST 2006
[EMAIL PROTECTED] ~]#
heh. Now I just have to figure out how to do stuff! :)
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
the database
is stopped it must be restarted? Hmm. And there are different levels
of users for the database, apparently. Bit of adjustment required!
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/opt/
total 0
[EMAIL PROTECTED] ~]$ mysql -u thufir -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.1.16
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql quit
Bye
[EMAIL PROTECTED] ~]$ date
Wed Feb 1
to be either that or
mysql insert into A (one, two, three) values (1 , 2, 3);
Either option seems a bit much. Perhaps there's something akin to
Access's form builder?
-Thufir
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
60 matches
Mail list logo