Export phpMyAdmin problems -


i have built wordpress site on local host through mamp , want export live site. believe have export wordpress database phpmyadmin, when select database , go export tab , push go on quick export method, taken screen , not downloadable box appears , no let me download database.

if localhost operating system linux, advice export database manually.

type on shell prompt while replacing what's inside brackets own values :

mysqldump -u [your_username] -p[your_password] [wordpress_database_name] > /tmp/[wordpress_database_name].sql 

this export database inside /tmp/ folder in file called wordpress_database_name.sql.

this command can used on windows if installed mariadb or mysql server, comes utilities needed export. have change directory in command prompt until inside binary utilities directory (it's "c:\program files\mariadb\bin\"), , type :

mysqldump.exe -u [your_username] -p[your_password] [wordpress_database_name] > [wordpress_database_name].sql 

it same shell command before in "bin" directory.

don't hesitate if need explained again.


Comments

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

angularjs - Showing an empty as first option in select tag -

php - Cloud9 cloud IDE and CakePHP -