Kapalı

Mysql DB Cleanup

I have a tracking script I use for affiliate marketing that tracks clicks and conversions. I have been using it for a few years and I have accumulated almost 7 million clicks. The database is almost 6000 mb. The database has about 2 dozen tables but most of the data is in 9 tables.

What I want is to remove data from those tables before a certain date. I pretty much want to remove all data before Jan 1 2012. Hopefully this is possible and will speed up the tracking script because it has slowed down over the years.

Beceriler: MySQL

Daha fazlasını gör: speed date script, mysql pretty, cleanup data mysql, script affiliate marketing, mysql cleanup script, mysql database cleanup script, mysql affiliate script, MySQL database cleanup, affiliate tracking mysql, database cleanup script, data conversions, cleanup tables database, mysql cleanup, cleanup script, mysql remove, mysql date picker, mysql date date range, mysql date today, mysql speed, php mysql date time system administrator

İşveren Hakkında:
( 298 değerlendirme ) Milwaukee, United States

Proje NO: #4089749

Bu iş için 23 freelancer ortalamada $83 teklif veriyor

stdhtelkom

Hi, I would love to help you. Please check pmb for my solution. All the best, Steve

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(19 Değerlendirme)
6.0
pivn

Let expert do this

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(54 Değerlendirme)
5.4
pablotorres

i can do it

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(67 Değerlendirme)
5.3
techvolcano

Mysql expert.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(50 Değerlendirme)
5.4
RedhopIT

Hello, Please check PM

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(25 Değerlendirme)
5.3
spriditis

Web developer. Can delete records older than 1. Jan 2012 from MySQL DB. See PM for questions..

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(31 Değerlendirme)
4.7
PhilipClarke

Hi, I'm British, in the UK and available immediately. I've been around for a long time, a lot of my work is in open source projects including phpMyAdmin. Also fpdf which generates pdf reports from mysql database, dy Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
4.7
opengeek

Ready to start asap. Thanks

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(41 Değerlendirme)
4.8
GandalfTheGrey

I'm experienced Linux system and database administrator. I could help you with your database optimization (and/or purging old records if needed).

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
4.4
developer287

i am expert php & mysql developer and i will be the fastest one to clean all the old entries from database.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(17 Değerlendirme)
4.3
lfr2

I have strong knowledge in mysql. I'm reliable, efficient coder. I'm ready to start.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)
3.8
parthaguha

I am ready for your job.

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(21 Değerlendirme)
3.8
f1x3r

Hi, I am experienced database administrator. I can handle this quickly.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
3.6
AccuPro

Hello, I can help.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
3.5
srsumon

I can do this.

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
2.8
lkimmeringer

Hi, I use MySQL for my development as professional Java developer. Deleting data from tables should be easy, but first I'd like to check your DB if the access can be optimized so you can keep the data instead of removi Daha Fazla

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)
2.7
lokeshk9936

Hi, Please see PM.

in %bids___i_period_sub_35% gün içinde120%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.6
SmileServe

Have done this before, ready to start and complete today.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.8
R0b0t

Hello, I can get this done in under an hours time. Thank you for your consideration.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
2.4
stallbd

Please let me prove I am perfect to work with your given job. And if you need to show any information then just tell me please. I'll show everything to prove. Thank you.

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
2.9