Export, Import MySQL db between different servers through Linux command line

You should have Database name, Database Username, Database Password and command line access to your server Export database to local file system, for example /var/www/html Arvind KumarHello Friends, I’m Arvind Kumar, founder of Inimist Technologies, Inimist Academy, The Fundabook and…

Read More

How to search replace string text in a table field in mysql

I have a date field in my mysql database table. I want to replace year 2017 in this field to 2019 Following command would do this. UPDATE races SET `date` =REPLACE( `date` , ‘2018’, ‘2019’ ) WHERE INSTR( `date` , ‘2018’ ) >0 Just saving it for reference here. Arvind KumarHello Friends, I’m Arvind Kumar, founder…

Read More