Can anyone recommend me a site wherein i can solve questions in SQL with all difficulty levels?

So your message is not relevant for the group , I’ll delete it

How to take MySQL incemntal. Backup of MySQL db

Binlogs is used for incremental backups..u have to enable the binlogs

Ok it’s enabled tq
Can you share the syntax for incremental backup

Mysqlbinlog binlog.xxxx l mysql -u -p

To see listing of all binary logs use- show binary logs;

Hai I have restored with full back and it shows all data but when I restore with incremental backup DB doesn’t show any modified data

Any idea ??

We have an opening for: Database Developer/Architect / Senior Associate/Senior Database Developer/Architect / Team Lead – Data Management and Databases
Contact information: Rahul Panwar
Mobile Number : +91 8130706999
Email id : rahul.panwar@globetouch.com
LinkedIn Profile: https://www.linkedin.com/in/mrrahulpanwar/

Can anyone recommend me a site wherein i can solve questions in SQL with all difficulty levels?

you must specify job place and conditions, or else i’ll delete the message.

sql.ru

Thanks man!

but you will not like it…

did u find the solution ..?

Yes

It worked on my testing environment

mysqldump -u username -p password databasename >name.sql

This one is for full backup ?

yes i mean whole db backup

We have an opening for: Database Developer/Architect / Senior Associate/Senior Database Developer/Architect / Team Lead – Data Management and Databases
Contact information: Rahul Panwar
Mobile Number : +91 8130706999
Email id : rahul.panwar@globetouch.com
LinkedIn Profile: https://www.linkedin.com/in/mrrahulpanwar/

Will share the resume for the same

single db all tables

I am trying to get incremental backup

ok ill check

I got it

Thanks for the reply

☝️

Good

Same thing I told yesterday that u can also use bin logs …same logs also used for replication

Rahul ji resume sent for DBA profile mssql Nd mysql from mayank19in@gmail.com

How can someone use binary log for an incremental backup and restore of a DB?
Can you send links on articles on this?

https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/mysqlbackup.incremental.html

wlcm

It’s not properly a increment backup but we can restore to a point from binlogs and also use gtid …

Yes you are right but I got some issue on my.cnf file now it fixed

Hi..I have a one table with auto_increment field…after insert it gives correct value in auto_increment field but not updating the value of auto_increment. Value in information_schema.tables table.

Why this happens? What is the solutions for this

Hi Hitesh would u check the value of the same by show create table tablename

How do y you see that auto increment value is not updated?

send screen shot

No, send text please

tell me the error

Screen shots are useless

what u get in my.cnf

Their is a field in information_schema.tables view with name auto_increment from their I can see the next auto_increment values

Here it is showing correct value

No, this field should not be updated with each insert

So it is normal this field doesn’t change