="INSERT INTO wp_users (ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name) VALUES ("&A4&", '"&B4&"', MD5('"&E4&"'), '"&LOWER(B4)&"', '"&LOWER(B4)&"@gmail.com', '', '2021-01-018 11:33:20', '1609932803:$P$B7LBiFY6NR6NrXFrSCrO7/54DqNi8B/', 0, '"&C4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'nickname', '"&B4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'first_name', '"&C4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'last_name', '');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'description', '');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'rich_editing', 'true');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'syntax_highlighting', 'true');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'comment_shortcuts', 'false');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'admin_color', 'fresh');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'use_ssl', '0');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'show_admin_bar_front', 'true');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'locale', '');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'wp_capabilities', 'a:1:{s:10:\""subscriber\"";b:1;}');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'wp_user_level', '0');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'um_multiple_roles', 'a:2:{i:0;s:23:\""um_erlms-entry-operator\"";i:1;s:14:\""um_data-viewer\"";}');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'um_user_profile_url_slug_user_login', '"&B4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'account_status', 'approved');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'sw_pwd', '"&E4&"');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'dismissed_wp_pointers', 'wp496_privacy');"
="INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES("&A4&", 'synced_gravatar_hashed_id', '354fbe8cea21bca9871847af17cb1970');"
="INSERT INTO t_site_user_map (UserId, InstanceId, IsActive) VALUES('"&A4&"', 1580086744006, 1);"
mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_wp_users.sql
mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_wp_usermeta.sql
mysql -u root -p erlms_drc_test_db < D:\erlmsdrc\INSERT_INTO_t_site_user_map.sql
mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_wp_users.sql mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_wp_usermeta.sql
mysql -u infomedr_dbadmin '-pDdFxDkuFRdf8Kdp' infomedr_erlms_master < /home/infomedrdc/public_html/INSERT_USER_WP_MANUALLY/INSERT_INTO_t_site_user_map.sql
Git & Github all commands list
git config –list
git config –global init.defaultBranch main
git config –global user.email “anwarcs36@yahoo.com”
git config –global user.name “Anwar Hossain”
git config –list
git init
git add .
git commit -m “first commit”
git remote add origin https://github.com/softworksbd/DyeManagerV2.git
git push -u origin master
git clone –branch branchname
or
git clone -b branchname
git clone -b development https://github.com/softworksbd/DyeManagerV2.git
git log
git log –oneline
How to create laravel project – Procedure 1
laravel new laravtutswag7
cd laravtutswag7
composer require laravel/ui
php artisan ui vue --auth
npm install && npm run dev
npm run dev
php artisan serve
http://127.0.0.1:8000
create database in your database - laravtutswag7
php artisan migrate
http://127.0.0.1:8000
create a user and login
Replace home.blade.php code with the following code block.
@extends('layouts.app')
@section('content')
<example-component></example-component>
@endsection
How to Install SSL Certificate on Ubuntu Server using Apache
How to create Godaddy subdomain
Create a record in dns section in godaddy portal not in whm
Type : A
Host : erlms
Points to : 197.174.228.143
TTL : Custom
Seconds : 600
InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files
2020-10-12 15:12:52 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.
I have faced the same problem. I just followed the below steps
Step 1: Moved(cut/paste) all the files in C:\xampp\mysql\data to desired backup location.
Step 2: After that copied all the files from C:\xampp\mysql\backup to C:\xampp\mysql\data
Step 3: Restarted mysql and checked the phpmyadmin url, it worked.
Step 4: After that stopped mysql that copied ibdata1 file from backup location to C:\xampp\mysql\data
Step 5: Restarted mysql
Step 6: After that copied all database folders and checked all the tables, It worked.