... this
operation needs to be scripted, or to be presented as one command line
that can be copy-and-pasted.
How can I do something like :
mysqladmin -h db_server -u user -pPASSWORD DATABASE truncate table
table1 ?
--
***
* John Oliver
On Tue, Mar 16, 2010 at 02:12:42PM -0700, John Oliver wrote:
Is there a way to use mysqladmin (or mysql) to truncate a table as a
one-off command from the command line?
I have an issue with importing data from one database into another, but
the second database might have columns
...
--
***
* John Oliver http://www.john-oliver.net/ *
* *
***
--
MySQL
what I can do about a stray pointer.
--
***
* John Oliver http://www.john-oliver.net
-pointer? Aborting backtrace!
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html
contains
information that should help you find out what is causing the crash.
100104 16:43:51 mysqld ended
--
***
* John Oliver
to a private VLAN on a virtual switch that is
only for these two servers. MySQL only listens on 172.16.1.1, and the
web server connects to that IP. On each host, I have a hosts entry for
the other.
--
***
* John Oliver
'@'host.name' but
just 'user' I *think* it's resetting the password for both... the
hashes are always the same. But I just don't know.
What am I missing?
--
***
* John Oliver http://www.john-oliver.net
from 'users' where COLUMN_NAME = 1898;
Is that right? I'm not sure if COLUMN_NAME is uid or id or maye
something else, and since I can't pipe it through more or less... :-)
--
***
* John Oliver http
to specify
rows 1000-1050. And then I'm guessing that mysql result.sql would
restore? Or would it not know what table it came from, and I'd have to
specify that?
--
***
* John Oliver http://www.john
the config
(it's set in settings.php as well as several places in the httpd.conf)
I do have /etc/hosts entries on both VMs resolving both 172.16.1.1 / 2
to known hostnames.
--
***
* John Oliver http
On Fri, Feb 14, 2003 at 05:01:01PM +0200, Egor Egorov wrote:
On Friday 14 February 2003 01:06, John Oliver wrote:
I removed the Red Hat MySQL RPMs (which worked fine, other than not
supporting InnoDB) and installed the 3.23.55-1 RPMs from mysql.com When
I try to start it:
[joliver
...
[joliver@joliver-lnx joliver]$ rpm -qa | grep automake
automake-1.6.3-1
automake14-1.4p6-3
automake15-1.5-4
--
John Oliver, CCNAhttp://www.john-oliver.net/
Linux/UNIX/network consulting http://www.john-oliver.net/resume/
*** sendmail, Apache, ftp, DNS
I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I
enable InnoDB?
--
John Oliver, CCNAhttp://www.john-oliver.net/
Linux/UNIX/network consulting http://www.john-oliver.net/resume/
*** sendmail, Apache, ftp, DNS, spam filtering
On Thu, Feb 13, 2003 at 03:33:31PM -0600, Paul DuBois wrote:
At 12:43 -0800 2/13/03, John Oliver wrote:
I've got MySQL installed via RPM on a Red Hat 8.0 machine. How do I
enable InnoDB?
If it's MySQL 4, install the -Max RPM on top of your existing installation
to get a server with InnoDB
them a shot. Thanks...
--
John Oliver, CCNAhttp://www.john-oliver.net/
Linux/UNIX/network consulting http://www.john-oliver.net/resume/
*** sendmail, Apache, ftp, DNS, spam filtering ***
Colocation, T1s, web/email/ftp
me much, either :-(
--
John Oliver, CCNAhttp://www.john-oliver.net/
Linux/UNIX/network consulting http://www.john-oliver.net/resume/
*** sendmail, Apache, ftp, DNS, spam filtering ***
Colocation, T1s, web/email/ftp
thread_concurrencycurrent value: 10
thread_cache_size current value: 0
tmp_table_sizecurrent value: 33554432
thread_stack current value: 65536
wait_timeout current value: 28800
--
John Oliver, CCNAhttp://www.john-oliver.net/
Linux/UNIX
17 matches
Mail list logo