Updating Magento 2 is very simple however, I would like to stress the importance of backing up your database BEFORE running any upgrade. I’d also like to HIGHLY suggest you do NOT do this on a production site until you’ve tested either locally or on a dev/staging environment. You will[…]
Read More »insert into admin_user select (select max(user_id) + 1 from admin_user) user_id, ‘FIRSTNAME’ first_name, ‘LASTNAME’ last_name, ‘myemail@noemailaddress.com’ email, ‘USERNAME’ username, MD5(‘NEWPASSWORDHERE’) password, now() created, NULL modified, NULL logdate, 0 lognum, 0 reload_acl_flag, 1 is_active, (select max(extra) from admin_user where extra is not null) extra, NULL, NULL; insert into admin_role select (select[…]
Read More »There are many tutorials out there that show you how to install Magento using SSH, but in my experience, there is always something that is missing. Here’s a collection of what I’ve found to work. I am using the Magento Sample data on this installation as well. For those of[…]
Read More »Open terminal and cd to the location of your file then do the following: $ scp [filename.extension] [username@serverIP]:[folder]/. example using actual names $ scp 3.tar myusername@192.168.1.1:public_html/.
Read More »Login as adminonly via ssh. SU Root cd ../ ../ to get to your sites directory type mysql -u <USERNAME> -p Press Enter Enter password Type Use <DBNAME> Type Source <filename.sql> Wait until the mysql prompt appears and it’s all done. **Do not type the <> in the example[…]
Read More »