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 ha
ll, which won't work... 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 truncate table
table1 ?
--
****
y the deltas?
Thanks...
--
*******
* John Oliver http://www.john-oliver.net/ *
* *
*
ace!
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
I don't know what I can do about a "stray pointer".
--
*******
* John Oliver
blic, and one private. The private
interfaces are connected 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.
--
****
go to reset passwords, it doesn't
want to let me specify 'user'@'ip.address' or 'user'@'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 miss
from 'users' where = 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
table_name" and then add something 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?
--
*******
* Jo
d 'user'@'hostname', and then go in and start modifying 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.
--
**
do *not* have an old Automake...
[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/
***
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
>
out current value: 3600
slow_launch_time current value: 2
sort_buffer current value: 2097144
table_cache current value: 64
thread_concurrencycurrent value: 10
thread_cache_size current value: 0
tmp_table_sizecurrent value: 33554432
thread_stack
e isn't helping 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
key-dokey, I'll give 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 ***
Coloca
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 exist
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 filt
17 matches
Mail list logo
