09-03-2010
Its a local import. I am using Fedora-13 and mysql -> mysql Ver 14.14 Distrib 5.1.48, for redhat-linux-gnu (i386) using readline 5.1
Any other suggestion.
Top Detail is ok
top - 13:27:31 up 2 days, 7:58, 1 user, load average: 2.01, 2.02, 2.00
Tasks: 209 total, 1 running, 208 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.5%us, 0.4%sy, 0.0%ni, 87.3%id, 10.8%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4117608k total, 4001592k used, 116016k free, 140236k buffers
Swap: 8388600k total, 12k used, 8388588k free, 3603904k cached
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
MySQL on my server is down....
I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock
Any suggestions?
Here's what I can't do:
can't be root
don't have physical access (do stuff via SSH)
reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies
2. Shell Programming and Scripting
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
Discussion started by: Danny_10
11 Replies
3. Shell Programming and Scripting
No help guys??? :(
Hi guys, i've got a question here... my intention is to write a script that would access a mysql db and extract some info and paste it into a file...
so the first move would be, to access the mysql interface right? hence...
#! /usr/bin/ksh
echo "Job Begin: " `date`
... (1 Reply)
Discussion started by: 12yearold
1 Replies
4. Programming
In a default package, there are BankTest.java and package bank wich contains Account.class .
// File: BankTest.java
import bank.*;
public class BankTest {
public static void main(String args)
{
Account account;
...
}
}
Trying to compile BankTest.java,... (0 Replies)
Discussion started by: Luke Bonham
0 Replies
5. UNIX and Linux Applications
:confused: hi all, RHEL 4 has installed on the server, when i use rpm -i command to install mysql5.1 enterprise version, error failed dependencies occurs as below:
mysql conflicts with mysql-4.1.22-2.el4.i386
mysql conflicts with mysql-4.1.22-2.el4.x86_64
have tried rpm -e which was... (2 Replies)
Discussion started by: maxlee24
2 Replies
6. Web Development
Hi, I had a chance to create a database refreshing the previous post. An error was tossed out with the following message:DBI connect('nr20111117_db','yifangt',...) failed: Unknown database 'nr20111117_db' at create-nrDB-20111214.pl line 17
Cannot connect: Unknown database 'nr20111117_db' at ... (6 Replies)
Discussion started by: yifangt
6 Replies
7. AIX
Hi,
Trying to setup mediawiki on a system but having problems configuring mysql:
CC=/usr/bin ./configure
checking build system type... powerpc-ibm-aix6.1.0.0
checking host system type... powerpc-ibm-aix6.1.0.0
checking target system type... powerpc-ibm-aix6.1.0.0
checking for a... (9 Replies)
Discussion started by: vpundit
9 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I am trying to import a database in putty with the syntax:
mysql –u database_username –p database_name < filename.mysql
As you can see in the screenshot it asks me for the database password - which suggests that the syntax is correct - but then after I enter the password it gives... (2 Replies)
Discussion started by: Juc1
2 Replies
9. UNIX and Linux Applications
Hi all,
i face a problem on (oracle database) installed on server Linux i need to export back as dump file, when i try to export give me the below error.
# expdp system/oracle directory=test dumpfile=Prodfb20150311.dmp logfile=Prodfb20150311.log FULL=y
Export: Release 11.2.0.1.0 -... (2 Replies)
Discussion started by: clerck
2 Replies
10. UNIX for Beginners Questions & Answers
HI
I have a dsv file that looks like:
<<BOF>>
record_number|id_number|first name|last name|msisdn|network|points|card number|gender
312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M
313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M... (4 Replies)
Discussion started by: tera
4 Replies
LEARN ABOUT CENTOS
mysql_tzinfo_to_sql
MYSQL_TZINFO_TO_S(1) MySQL Database System MYSQL_TZINFO_TO_S(1)
NAME
mysql_tzinfo_to_sql - load the time zone tables
SYNOPSIS
mysql_tzinfo_to_sql arguments
DESCRIPTION
The mysql_tzinfo_to_sql program loads the time zone tables in the mysql database. It is used on systems that have a zoneinfo database (the
set of files describing time zones). Examples of such systems are Linux, FreeBSD, Solaris, and Mac OS X. One likely location for these
files is the /usr/share/zoneinfo directory (/usr/share/lib/zoneinfo on Solaris). If your system does not have a zoneinfo database, you can
use the downloadable package described in Section 9.6, "MySQL Server Time Zone Support".
mysql_tzinfo_to_sql can be invoked several ways:
shell> mysql_tzinfo_to_sql tz_dir
shell> mysql_tzinfo_to_sql tz_file tz_name
shell> mysql_tzinfo_to_sql --leap tz_file
For the first invocation syntax, pass the zoneinfo directory path name to mysql_tzinfo_to_sql and send the output into the mysql program.
For example:
shell> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them. mysql processes those statements to load
the time zone tables.
The second syntax causes mysql_tzinfo_to_sql to load a single time zone file tz_file that corresponds to a time zone name tz_name:
shell> mysql_tzinfo_to_sql tz_file tz_name | mysql -u root mysql
If your time zone needs to account for leap seconds, invoke mysql_tzinfo_to_sql using the third syntax, which initializes the leap second
information. tz_file is the name of your time zone file:
shell> mysql_tzinfo_to_sql --leap tz_file | mysql -u root mysql
After running mysql_tzinfo_to_sql, it is best to restart the server so that it does not continue to use any previously cached time zone
data.
COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 MYSQL_TZINFO_TO_S(1)