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
Post a Comment