Makitweb - Page 44 of 102 -

How to import SQL file to MySQL using Command Line

Last updated on June 3, 2023 by Yogesh Singh

Developers, database administrators, and individuals involved with databases often need to import SQL files into a MySQL database for various reasons such as updating or configuring the database. These SQL files typically include significant data, table structures, and required configurations that enable smooth setup or modification of a database instance.

GUIs can be used to import SQL files, but using Command Line Interface (CLI) has advantages. It’s faster and more efficient with greater flexibility and various scenarios such as remote server work or integration with scripts and automated processes.

This article guides the reader on how to import SQL files to MySQL using Command Line. Whether a MySQL newbie or an experienced user looking to improve database management skills, mastering this technique allows efficient handling of SQL file imports and ensures smooth data management in all projects.

I am using XAMPP in Windows for accessing the database using phpMyAdmin.

How to import SQL file to MySQL using Command Line

Custom file upload in CKEditor with PHP

Last updated on January 15, 2020 by Yogesh Singh

In CKEditor by default file browser option is not enabled.

You can only add a file to an editor with URL.

To add file browser option require to update CKEditor configuration and use options while initialization.

In this tutorial, I show how you can add file browser option in CKEditor and upload it with PHP.

How to Store Array in MySQL with PHP

Last updated on March 13, 2023 by Yogesh Singh

An array is a special variable that allows storing one or more values in a single variable e.g. – holding usernames or details in an Array.

They are easier to access and manipulate.

Sometimes, require to store Array in the MySQL database and retrieve it.

In this tutorial, I show how you can store an Array in the MySQL database and read it with PHP.

How to Store Array in MySQL with PHP

Integrate CKEditor to HTML page and save to MySQL with PHP

Last updated on February 9, 2020 by Yogesh Singh

CKEditor is a WYSIWYG HTML editor.

It makes HTML textarea lot more user-friendly by providing various features like – adding images, writing HTML code, formatting text, etc.

This can also be added to HTML containers.

It does not depend on other libraries like – jQuery and can be used in 3 different modes – Article Editor, Document Editor, and Inline Editor.

Different options are available to customize the editor.

In this tutorial, I am adding Article and Inline mode CKEditor on the same page and save it to MySQL database on submit with PHP.