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

|
MasterZiv 2020-01-28 10:15:41
Diksha Goyal 2020-01-28 10:14:28
I m using MS SQL server n i don’t know is there any difference between both of them

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

Nabeel 2020-01-28 10:18:49
How to take MySQL incemntal. Backup of MySQL db
Mayank Maheshwari 2020-01-28 10:19:40
Binlogs is used for incremental backups..u have to enable the binlogs
Nabeel 2020-01-28 10:21:15
Ok it’s enabled tq
Can you share the syntax for incremental backup
Mayank Maheshwari 2020-01-28 10:24:56
Mysqlbinlog binlog.xxxx l mysql -u -p
Mayank Maheshwari 2020-01-28 10:26:02
To see listing of all binary logs use- show binary logs;
Nabeel 2020-01-28 13:40:16
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
Nabeel 2020-01-28 13:40:27
Any idea ??
Choudhary_Rahul_Panwar 2020-01-29 11:04:38
mysql_en-1667.jpg

Choudhary_Rahul_Panwar 2020-01-29 11:04:55
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/
notpeepeepoopoo 2020-01-29 11:19:06
Can anyone recommend me a site wherein i can solve questions in SQL with all difficulty levels?
MasterZiv 2020-01-29 11:21:11
Choudhary_Rahul_Panwar 2020-01-29 11:04:55
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/

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

MasterZiv 2020-01-29 11:21:31
notpeepeepoopoo 2020-01-29 11:19:06
Can anyone recommend me a site wherein i can solve questions in SQL with all difficulty levels?

sql.ru

notpeepeepoopoo 2020-01-29 11:22:41
MasterZiv 2020-01-29 11:21:31
sql.ru

Thanks man!

MasterZiv 2020-01-29 11:23:17
notpeepeepoopoo 2020-01-29 11:22:41
Thanks man!

but you will not like it…

ICUI4CUtwo 2020-01-29 11:50:12
Nabeel 2020-01-28 10:18:49
How to take MySQL incemntal. Backup of MySQL db

did u find the solution ..?

Nabeel 2020-01-29 12:32:33
Yes
Nabeel 2020-01-29 12:32:53
It worked on my testing environment
ICUI4CUtwo 2020-01-29 12:33:56
mysqldump -u username -p password databasename >name.sql
Nabeel 2020-01-29 12:34:37
ICUI4CUtwo 2020-01-29 12:33:56
mysqldump -u username -p password databasename >name.sql

This one is for full backup ?

ICUI4CUtwo 2020-01-29 12:35:03
yes i mean whole db backup
Mayank Maheshwari 2020-01-29 12:35:19
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/
Mayank Maheshwari 2020-01-29 12:35:19
Will share the resume for the same
ICUI4CUtwo 2020-01-29 12:35:19
single db all tables
Nabeel 2020-01-29 12:35:47
I am trying to get incremental backup
ICUI4CUtwo 2020-01-29 12:36:07
ok ill check
Nabeel 2020-01-29 12:36:25
I got it
Nabeel 2020-01-29 12:36:32
Thanks for the reply
Nabeel 2020-01-29 12:37:05
mysql_en-1688.jpg

Nabeel 2020-01-29 12:37:20
☝️
ICUI4CUtwo 2020-01-29 12:41:51
Good
Mayank Maheshwari 2020-01-29 12:42:56
Same thing I told yesterday that u can also use bin logs …same logs also used for replication
Mayank Maheshwari 2020-01-29 13:06:18
Rahul ji resume sent for DBA profile mssql Nd mysql from mayank19in@gmail.com
MasterZiv 2020-01-29 13:10:11
Mayank Maheshwari 2020-01-29 12:42:56
Same thing I told yesterday that u can also use bin logs …same logs also used for replication

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

ICUI4CUtwo 2020-01-29 13:11:22
https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/mysqlbackup.incremental.html
ICUI4CUtwo 2020-01-29 13:16:27
wlcm
Mayank Maheshwari 2020-01-29 13:22:35
It’s not properly a increment backup but we can restore to a point from binlogs and also use gtid …
Nabeel 2020-01-29 13:26:02
Mayank Maheshwari 2020-01-29 12:42:56
Same thing I told yesterday that u can also use bin logs …same logs also used for replication

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

HK 2020-01-29 14:10:24
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

Mayank Maheshwari 2020-01-29 14:12:19
Hi Hitesh would u check the value of the same by show create table tablename
MasterZiv 2020-01-29 14:16:29
HK 2020-01-29 14:10:24
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

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

ICUI4CUtwo 2020-01-29 14:16:47
Nabeel 2020-01-29 13:26:02
Yes you are right but I got some issue on my.cnf file now it fixed

send screen shot

MasterZiv 2020-01-29 14:17:14
ICUI4CUtwo 2020-01-29 14:16:47
send screen shot

No, send text please

ICUI4CUtwo 2020-01-29 14:17:36
tell me the error
MasterZiv 2020-01-29 14:17:36
Screen shots are useless
ICUI4CUtwo 2020-01-29 14:17:53
what u get in my.cnf
HK 2020-01-29 14:18:51
MasterZiv 2020-01-29 14:16:29
How do y you see that auto increment value is not updated?

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

HK 2020-01-29 14:20:18
Mayank Maheshwari 2020-01-29 14:12:19
Hi Hitesh would u check the value of the same by show create table tablename

Here it is showing correct value

MasterZiv 2020-01-29 14:20:18
HK 2020-01-29 14:18:51
Their is a field in information_schema.tables view with name auto_increment from their I can see the next auto_increment values

No, this field should not be updated with each insert

MasterZiv 2020-01-29 14:20:43
HK 2020-01-29 14:18:51
Their is a field in information_schema.tables view with name auto_increment from their I can see the next auto_increment values

So it is normal this field doesn’t change

|