Monday, February 5, 2018

MySQL Server has Gone Away

 Just left-click wamp icon then choose 'MySQL' then choose my.ini :
 Enlarge the size of 'max_allowed_packet' :
Restart wamp..... aaaanddd doneeee... ;)

Exporting and Importing Amazon RDS using HeidiSQL to Our local Devs Server

First thing first... Login to your amazon rds using heidi :

After that, right click on database that we wanted to export then choose 'Export database as SQL'...


Just hit 'Export' button and wait until it finishs.... :v

When it finished...


Next  step is importing the exported file to ourlocal server... So please running your xampp or wampp... and the connect the heidisql to your local server

Create a new database...

We can actually choose 'Load file(s) into the editor'..... ;)

and then just wait until it finished up... :v

Actually there is another way of thing this.... When exporting the sql from amazon we can actually automatically import it to our local like this :