PHP mysql data dumping (award very fast. Fist come first serve) Urgent
4502
$150
- Posted:
- Proposals: 1
- Remote
- #108131
- Archived
Description
Experience Level: Intermediate
HI
I have over 25,000 product in .sql file to dump into a DB for a website. I have all set of data to be imported through phpmyadmin to appropriate fields.
Every time i do it the server overloads. and I get the following when i check the logs.
load average: 9.04, 8.38, 7.05
11379 mysql 18 0 146m 33m 5324 S 101.0 5.3 315:51.52 mysqld
Jason T: | 2758 | tewfic_wadmin | localhost | tewfic_watch | Query | 695 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 2811 | tewfic_wadmin | localhost | tewfic_watch | Query | 35 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 2995 | tewfic_wadmin | localhost | tewfic_watch | Query | 39 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 2998 | tewfic_wadmin | localhost | tewfic_watch | Query | 34 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 3030 | tewfic_wadmin | localhost | tewfic_watch | Query | 26 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 3852 | tewfic_wadmin | localhost | tewfic_watch | Sleep | 0 | | |
Jason T: | 4198 | tewfic_wadmin | localhost | tewfic_watch | Query | 423 | Copying to tmp table | Select distinct tbl_product.prd_id, prd_code, prd_title, our_price, sale_price, prd_img, aff_product |
Jason T: | 4218 | tewfic_wadmin | localhost | tewfic_watch | Query | 180 | Copying to tmp table | Select distinct tbl_product.prd_id, prd_code, prd_title, our_price, sale_price, prd_img, aff_product |
Jason T: | 4276 | root | localhost | | Query | 0 | | show processlist |
Jason T: +------+---------------+-----------+--------------+---------+------+----------------------+----
If you know what all the above means and you thing you can fix the problem get in touch.
I have over 25,000 product in .sql file to dump into a DB for a website. I have all set of data to be imported through phpmyadmin to appropriate fields.
Every time i do it the server overloads. and I get the following when i check the logs.
load average: 9.04, 8.38, 7.05
11379 mysql 18 0 146m 33m 5324 S 101.0 5.3 315:51.52 mysqld
Jason T: | 2758 | tewfic_wadmin | localhost | tewfic_watch | Query | 695 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 2811 | tewfic_wadmin | localhost | tewfic_watch | Query | 35 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 2995 | tewfic_wadmin | localhost | tewfic_watch | Query | 39 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 2998 | tewfic_wadmin | localhost | tewfic_watch | Query | 34 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 3030 | tewfic_wadmin | localhost | tewfic_watch | Query | 26 | Sending data | Select count(distinct(tbl_product.prd_id)) as cnt from tbl_product inner join tbl_product_brand on t |
Jason T: | 3852 | tewfic_wadmin | localhost | tewfic_watch | Sleep | 0 | | |
Jason T: | 4198 | tewfic_wadmin | localhost | tewfic_watch | Query | 423 | Copying to tmp table | Select distinct tbl_product.prd_id, prd_code, prd_title, our_price, sale_price, prd_img, aff_product |
Jason T: | 4218 | tewfic_wadmin | localhost | tewfic_watch | Query | 180 | Copying to tmp table | Select distinct tbl_product.prd_id, prd_code, prd_title, our_price, sale_price, prd_img, aff_product |
Jason T: | 4276 | root | localhost | | Query | 0 | | show processlist |
Jason T: +------+---------------+-----------+--------------+---------+------+----------------------+----
If you know what all the above means and you thing you can fix the problem get in touch.
Tewfic K.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
14%
Last project
14 Dec 2011
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies