Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Mysql import problem

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Mysql import problem
# 1  
Old 09-03-2010
Mysql import problem
Dear folks,

i am importing a database since yesterday that is innodb tablespace, the space of dump file is 4GB, almost 24 pass out it is not yet complete. What should i do to import it fastly. I have disable foreign key check because it have some issues so thats why i am importing it with source and sqldump-filename.

Please suggest how i save time.
# 2  
Old 09-03-2010
Is it running through the network or is it a local import?

Is your CPU runnung at 100%? - I ask this because there is a bug in some versions of MySQL (<5.0.52):

MySQL Bugs: #33057: mysql command line client slows down and uses 100% CPU when restoring dump


Of course you can always perform a faster restore by using binary logs instead of dumpfiles.

Smilie
Last edited by verdepollo; 09-03-2010 at 11:11 AM..
# 3  
Old 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
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Using bash script : How to Import data from a dsv file into multiple tables in mysql

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

2. UNIX and Linux Applications

Problem in import & expdp Dump file

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

3. UNIX for Dummies Questions & Answers

SSH import mysql database

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

4. AIX

Configuring MySQL problem

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

5. Web Development

met problem with do() in MySQL

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

6. UNIX and Linux Applications

mysql conflicts problem

: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

7. Programming

Java import problem

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

8. Shell Programming and Scripting

Mysql problem

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

9. Shell Programming and Scripting

Problem with PHP and MySQL

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

10. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

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
Login or Register to Ask a Question