How to fetch & store over 100k records to DB from another DB
I have school database who having more then 80 000 records and I want to update and insert into my newSchool database using php, whenever I try to run query update or insert almost 2 000 records and after some time its stopped automatically please help
Don't paste your password here, but enter it after mysql asks for it. Using a password on the command line interface can be insecure.
Dump all tables in all databases. This is the same as using the --databases option and naming all the databases on the command line.
Include Event Scheduler events for the dumped databases in the output.
This option requires the EVENT privileges for those databases.
The output generated by using --events contains CREATE EVENT
statements to create the events. However, these statements do not
include attributes such as the event creation and modification
timestamps, so when the events are reloaded, they are created with
timestamps equal to the reload time.
If you require events to be created with their original timestamp
attributes, do not use --events. Instead, dump and reload the contents
of the mysql.event table directly, using a MySQL account that has
appropriate privileges for the mysql database.
Include stored routines (procedures and functions) for the dumped
databases in the output. Use of this option requires the SELE