Skip to navigation Skip to content
  • Code Affairs Web Technologies
  • Store
  • Downloads
  • Account
Code Affairs Web Technologies
  • Home
  • About Us
  • Shop
  • Woocommerce
  • WordPress
  • Security
  • Payment Gateways
  • Prestashop
  • Orders
  • Downloads
  • Account details
  • Lost password
  • Css
  • Git
  • JavaScript
  • VueJs
  • MySQL
  • News
  • Php
  • WordPress
  • Python
  • Server
  • Apache
  • Linux
  • Ubuntu
  • Tutorials
  • Uncategorized
  • Returning Customer ?

    Sign in

    Don't have an account ?

    Register
0 0.00$
All Categories (Incl. Shop)
  • Home
  • About Us
  • Shop
  • Woocommerce
  • WordPress
  • Security
  • Payment Gateways
  • Prestashop
  • Orders
  • Downloads
  • Account details
  • Lost password
  • Css
  • Git
  • JavaScript
  • VueJs
  • MySQL
  • News
  • Php
  • WordPress
  • Python
  • Server
  • Apache
  • Linux
  • Ubuntu
  • Tutorials
  • Uncategorized
  • Home
  • Blog
  • About Us
  • Contact
  • Home
  • About Us
  • Shop
  • Woocommerce
  • WordPress
  • Security
  • Payment Gateways
  • Prestashop
  • Orders
  • Downloads
  • Account details
  • Lost password
  • Css
  • Git
  • JavaScript
  • VueJs
  • MySQL
  • News
  • Php
  • WordPress
  • Python
  • Server
  • Apache
  • Linux
  • Ubuntu
  • Tutorials
  • Uncategorized
Code Affairs Web Technologies
  • Search
  • 0
HomeMySQL

Import Sql file to Mysql Database

MySQL 30/03/2019 23/04/2019 Diana Igorovna
For import sql file to database: mysql -uUsername -p database_name_backup.sql < database_name.sql Then write password and start import process. For compressed files like sql.bz2 : bunzip2 < database_filename.sql.bz2 | mysql
Read More
Leave a comment

Take a Database Backup on Terminal

MySQL 14/03/2019 23/04/2019 Diana Igorovna
It' simple to use mysqldump to taking a database backup on terminal: mysqldump -uDATABASEUSERNAME -pPASSWORD database_name > database_name.sql If you don't want to use the password with command line: mysqldump
Read More
Leave a comment

Create a database via MySQL console

MySQL 13/03/2019 23/04/2019 Diana Igorovna
Login to MySQL console in terminal use: mysql -u=root -p Create a database: Create Database DATABASENAME Character Set utf8mb4 Collate utf8mb4_unicode_ci; Define a user for the database: Grant All Privileges
Read More
Leave a comment

Categories

  • Css
  • Git
  • JavaScript
    • VueJs
  • MySQL
  • News
  • Php
    • WordPress
  • Python
    • Django
  • Server
    • Apache
    • Linux
    • Ubuntu
  • Tutorials
  • Uncategorized

Recent Posts

  • Create A Django Application 21/09/2019
  • Start Django Project 17/09/2019
  • Create Virtual Environment & Install Django 11/09/2019
  • How to Install Python And Django? 11/08/2019
  • Linux Help Commands 23/07/2019

Tags Clouds

apache apache2 create database css database backup event listener free ssl hello world help h parameter javascript Let's Encrypt linux linux help linux help commands mysql php php classes php static server size ssl ubuntu size v-html v-once virtual-host vue vue cli vuejs wordpress wordpress command line wp-cli

Code Affairs Web Blog

We are sharing contents here that things can help you. If you want to prefer us writing article that it can help everyone please contact us and send the title.

Featured Products

  • Saferpay Woocommerce 59.00$
  • woocommerce sms Zadarma Sms Plugin 21.00$
  • woocommerce category discount Category Discount
    Rated 4.83 out of 5
    11.00$

Top Selling Products

  • product-default-currency-woocommerce Product Default Currency
    Rated 5.00 out of 5
    16.00$ 21.00$
  • woocommerce category discount Category Discount
    Rated 4.83 out of 5
    11.00$
  • woocommerce sms Zadarma Sms Plugin 21.00$

On-sale Products

  • Saferpay Woocommerce 59.00$
  • woocommerce sms Zadarma Sms Plugin 21.00$
  • woocommerce category discount Category Discount
    Rated 4.83 out of 5
    11.00$
Sign up to Newsletter
...and get be first to knowour posts and products
Code Affairs Web Technologies
Got Questions ? Call us 24/7! +380 68 2531020
Contact Us
Code Affairs Web Technologies Yavirov, Lviv Oblast, Ukraine, Lviv

Give us a call, send us an email or message. We are always here to help out in whatever way we can.

Top Links

  • Home
  • Blog
  • About Us
  • Contact

Blog Categories

  • JavaScript
  • News
  • Server
  • Php
  • MySQL
  • Tutorials
  • Css
  • Git
  • Python
  • Tutorials

My Account

  • Orders
  • Downloads
  • Addresses
  • Account details
  • Logout
  • Lost password
© CodeAffairs - All Rights Reserved
Code Affairs Web Technologies
Got Questions ? Call us 24/7! +380 68 2531020