docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
No wonder the wp-cli command didn’t work, none of your containers are up. Try
ee service enable
ee service enable usage: ee service enable <service-name>
Hi again, what happens when you just type in
mysql in the terminal? You should see an error like this:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
If that shows up then it’s good news, you can export the DB.
mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8579 Server version: 10.1.38-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
Nice, type in:
Yes Its showing the databases:
MariaDB [(none)]> show databases; +---------------------+ | Database | +---------------------+ | bulkaccountshop_com | | information_schema | | mysql | | performance_schema | +---------------------+
Ok exit out of mysql and then type this:
mysqldump -u username -p bulkaccountshop_com > ~/bulkaccountshop_com.sql
Its comeleted but where is the file ?
It’s in your user’s home directory
It supposed to be under
root@cloud49:~# find ~/ -type f -name bulkaccountshop_com.sql /root/bulkaccountshop_com.sql root@cloud49:~#
BUt when I checked with file zilla there is nothing
It’s right there. I didn’t realize you were running as root.
It should be there but its not actually am installing zip
Yes in zip it worked thank you mate…
Output to root folder then
mysqldump -u username -p bulkaccountshop_com > /root/bulkaccountshop_com.sql
Oh you got it, cool.
Yes mate but thank you a lot for giving your time here
You can create a new WordPress admin user from within the database. Use this method if your original admin user was
- Log into phpMyAdmin ([cPanel]
Note: If you’re using cPanel Hosting, you must select the database for your WordPress site in the left-hand column before proceeding to the next step
- Click the _users table
- Click the Insert tab
- Fill in the following fields.
- ID is any number you choose
- user_login is the username for accessing the WordPress Dashboard.
- user_pass is the password for the user. Make sure to select MD5 in the functions menu
- user_nicename is the nickname for the user
- user_email is the email address you want to associate with this user
- user_registered is the date and time for when this user is registered
- user_status should be set to 0
- display_name is the name that will be displayed for this user on your site
- Click the Go button
- Click the _usermeta table
- Click the Insert tab
- Fill in the following fields:
- user_id is the ID you entered in the previous step
- meta_key should be the phrase wp_capabilities
- meta_value should be
9. Click Go
10. Click the Insert tab again
11. Enter the following information:
- user_id is the same number you entered in the previous step
- meta_key should be the phrase wp_user_level
- meta_value should be the number 10
- Click the Go button.
You can now login with the new Admin user.
Or wp-cli one liner
wp user create bob email@example.com --role=administrator