#how to import large sql file in phpmyadmin cpanel | Explore Tumblr posts and blogs

webinfotech · 1 month ago

Text

Migrate or move WordPress website to a new host in 2025

Why You Might Need to Move Your WordPress Site

Your website is important. But sometimes, your web host may be slow, expensive, or not helpful. When that happens, it’s smart to move your website to a better hosting company. A better host can help your site load faster, stay online, and keep visitors happy.

You can move your website in two ways:

Manually (you do everything step by step)

Automatically (you use a plugin to help)

This full guide will show you both ways. It will also teach you what to do after you move your site to make sure everything works.

If this sounds hard, don’t worry. You can also get help from Creation Wave LLC. We help people move WordPress websites safely and quickly.

Table of Contents

Manual vs Automatic Migration

Manual Migration – Step by Step

How to Move WordPress Without cPanel

How to Use a Plugin to Migrate Your Site

What to Check After Migration

Final Thoughts and Expert Help

Should You Move Your Site Manually or Use a Plugin?

There are two ways to move your WordPress site:

Manual Migration

This is where you download your files and database and upload them to the new host yourself. It gives you more control, but you need to be careful. One small mistake can break your site. This is better for large websites or people with some technical skills.

Automatic Migration

This uses a WordPress plugin to move your site. It is easier and faster. It is perfect for small websites or beginners. You don’t have to touch any code.

If you're not sure which to pick, try a plugin first. If it doesn't work or gives errors, you can move it manually or get expert help.

Need help? Creation Wave LLC offers both manual and automatic WordPress migration services.

Manual WordPress Migration (Step-by-Step Guide)

This part will show you how to manually move your WordPress website to a new host.

Step 1: Choose a New Hosting Company

Make sure your new host is fast, secure, and helpful. Look for companies that offer good customer support and daily backups.

Types of hosting:

Shared hosting (basic and cheap)

VPS hosting (faster and more private)

Managed WordPress hosting (easy and fully managed)

Dedicated server (for very large sites)

If you need help picking the right host, Creation Wave LLC can help you choose the best one.

Step 2: Backup Your WordPress Files

Your website files are very important. They include your theme, plugins, images, and settings.

To back them up:

Use an FTP client like FileZilla.

Connect to your old host using FTP login details.

Find the folder named “public_html” or your WordPress folder.

Download all the files to your computer.

Wait until the download finishes before going to the next step.

Step 3: Export Your Database

Your website database has all your posts, pages, user accounts, and comments.

To export it:

Open phpMyAdmin.

Click your WordPress database name on the left.

Click the “Export” tab at the top.

Choose “Quick” and “SQL” format.

Click “Go” to download the file.

Save this file in a safe place.

Step 4: Create a New Database on Your New Host

Now go to your new hosting account. Do this:

Log into cPanel.

Click “MySQL Databases.”

Create a new database.

Create a new user and give it a strong password.

Add the user to the database and give it all permissions.

Write down the database name, user name, and password. You will need them soon.

Step 5: Upload WordPress Files to New Host

Now it’s time to put your website files on the new server.

To upload:

Open FileZilla again.

Connect to your new host with your new FTP details.

Go to the folder named “public_html” or root folder.

Upload all your website files from your computer.

Wait for the upload to finish before moving on.

Step 6: Import Your Database

Now you need to import your old database to the new host.

Open phpMyAdmin.

Click your new database name.

Click the “Import” tab.

Choose the .sql file you downloaded earlier.

Click “Go.”

This will add your old content to your new hosting account.

Step 7: Update the wp-config.php File

WordPress needs to know how to connect to the database.

In FileZilla, find and open the file “wp-config.php.”

Right-click and choose Edit.

Update the database name, user, and password:

define('DB_NAME', 'your_new_db_name'); define('DB_USER', 'your_new_db_user'); define('DB_PASSWORD', 'your_new_password');

Save and close the file.

Now WordPress can talk to the new database.

Step 8: Point Your Domain to the New Host

This is the final step.

Log into the account where you bought your domain (like GoDaddy or Namecheap).

Find DNS or Nameserver Settings.

Change the nameservers to the new hosting company’s nameservers.

Save and wait.

It can take 1–24 hours for the DNS to update fully. After that, your site will be live on the new host.

How to Migrate Without cPanel

Some hosting providers don’t use cPanel. That’s okay. You can still migrate your website.

Here’s what to do:

Ask your host for FTP access and MySQL access.

Use FileZilla to upload files.

Use another tool like Adminer or CLI (command-line) to import your database.

Update your wp-config.php file as shown earlier.

If this sounds too technical, Creation Wave LLC can do it for you.

How to Use a Plugin to Migrate Your WordPress Site

If you want an easier way, use a migration plugin. Here are three good ones:

All-in-One WP Migration

Simple drag-and-drop tool.

Great for beginners.

Duplicator

Makes a full copy of your website.

Offers more options for developers.

UpdraftPlus (Paid)

Does backups and migrations.

Good support.

To use a plugin:

Install the plugin on your old website.

Use the plugin to export the full site.

Set up a clean WordPress install on your new host.

Install the same plugin there.

Import the file you exported earlier.

After a few minutes, your site should be live.

What to Check After Migration

After moving your website, test everything. Check the following:

Is your homepage loading fast?

Are all your pages and posts showing?

Are your images loading?

Can you log into the WordPress dashboard?

Are all your plugins working?

Is the site mobile-friendly?

Also test your contact forms, menus, and links. You can use free tools like GTmetrix or Google PageSpeed to check speed.

If anything looks broken, go back and check your steps.

Need help? Creation Wave LLC offers a full post-migration checkup.

Final Thoughts

Moving your WordPress website can feel scary. But with the right steps, it’s not so hard. This guide helps you move your site by yourself or with a plugin. You also learned how to test your site after moving.

A better host can give you faster speed, better uptime, and better support. If you don’t want to take risks or waste time, you can let experts do it for you.

1 note · View note

strangehoot · 5 years ago

Text

New Post has been published on Strange Hoot - How To’s, Reviews, Comparisons, Top 10s, & Tech Guide

New Post has been published on https://strangehoot.com/how-to-increase-mysql-upload-limit/

How to Increase MySQL Upload Limit on Server

MySQL is a free open source Relational Database Management System using Structured Query Language SQL, being the highly favourite language for content addition, access and management of a database. It is highly recommended for faster processing, utmost reliability, ease-of-work experience and flexible approach.

The utility of MySQL includes a broad spectrum of clients like e-commerce, logging applications and data warehousing, but the commonest of all is web database creation.

It stores and manipulates data through emphasizing on the relationship between the tables. Clients request the database thru pre-defined SQL statements to request response-information to get one on clients’ side.

DATABASE () function shows the name of the running database, which is an active one. Queries are subject to get results from and based on the running database. In MySQL, it is possible to substitute the function SCHEMA () with the function DATABASE ().

MySQL shell is an interactive tool to be used and act as an administrator of the MySQL database. Supporting JavaScript, Python or SQL modes has made it convenient for access and administrative use.

SQL being a standard language enabling the user to manage and design databases whereas, MySQL is a relational database management system permitting the storage and retrieval of data from the database. MySQL, at times, uses SQL to perform some specific operations.

The easiest and reliable way to connect to the MySQL server and get a MySQL databases list is running the SHOW DATABASES command. User can omit the -p switch, in case, the user has not set a password as a MySQL user. User can establish a connection to MySQL Database by logging into A2 Hosting account through SSH for which the user has to type the relevant command. The command need some changes like :-

Replace USERNAME with the username:

MySQL -u USERNAME -p.

Type the password at the Enter Password prompt, …

Type the command at the MySQL> prompt: SHOW DATABASES, to get a display of the list of databases.

Launch the MySQL Command-Line Client.

For launching the MySQL Command-Line client, the user must enter the below-given command in the Command Prompt window:

MySQL -u root -p

where -p option is required only in case of a root password has been defined for MySQL.

Users with a no-install package may use the instructions to install MySQL manually. For installing MySQL from a ZIP Archive package is as under:

Extract the main archive to the desired install directory

User may also extract the debug-test archive, which is optional in case plan is to execute the MySQL benchmark and test the software.

Option file can be created using the following commands:-

Choose a MySQL server type

Initialize MySQL

Start the server

Secure default user accounts

PHP, Hypertext Pre-processor is open source widely-used scripting language to be executed on the server. Rasmus Lerdorf generated the initial version of PHP in 1994 to be utilized in managing session tracking, dynamic content with PHP database. PHP is also used in building e-commerce sites.

The Server is a part of computer hardware/software in computing to offer functionality for the programs/devices, referred to as “clients”. The whole architecture is known as the client-server model.

Upload max file size is the maximum size for files that are being posted. The types of POST body data are not subject to the limit. In case you wish to upload large files, you must increase both limits.

Maximum execution time in PHP is of 30 seconds. The phrase “maximum execution time” is vague as it may be taken as

(a) elapsed time since the script started, or

(b) the total CPU time taken by the script, including or excluding the CPU time taken by OSC.

The maximum execution time by default for PHP scripts is taken to be 30 seconds. PHP stops the script and reports an error in case a script runs longer than maximum execution time. Amount of time PHP allows can be controlled by running the scripts for changing the maximum execution time directive in the php.ini file.

Client – Server Connection Ports

The default port used is Port 3306 for the classic MySQL (port) protocol. It is used by the MySQL Connectors, client, or for utilities like MySQL pump, MySQL dump. The port supported by MySQL Connectors or MySQL Shell or MySQL Router for X Protocol (mysqlx_port), is estimated by multiplying 10 to classic MySQL protocol port.

Increase upload / import size

You have a 2mb limit of upload/import size in MySQL which is totally odd and highly inconvenient to import large files. User can get the upload size increased by allowing and editing the server’s php.ini configuration file. Generally, it is located at /etc/php.ini in servers like CentOS.

The following commands can be typed to increase MySQL upload limit on the server

Step 1:

Go to php.ini and find the following and change the values to larger database size.

upload_max_filesize = 40M

post_max_size = 40M

Step2:

Restart the apache service for the new change to get set. Typically the command to restart apache would be: –

service httpd restart for CentOs

service apache2 restart for ubuntu

You can also restart directly from the path as :-

/etc/init.d/apache2 restart or /etc/init.d/httpd restart

In case of shared hosting with no root access or access to the php.ini configuration file, then another way is: –

to create a .ht access file in the application root and then adding the following line;

php_value upload_max_filesize 40M

php_value post_max_size 40M

Increase the MySQL Max Upload Size on Server

The cPanel server puts a cap on the database to be uploaded into PhpMyAdmin. The default limit is subjected to 50MB.

Therefore, it becomes difficult to upload a large database to PhpMyAdmin. But, to increase the max upload size in the PhpMyAdmin of the database file, the user can make changes in configuration in the WHM of the server like: –

Step 1:

Step 2:

Navigate to “Server Configuration”.

Step 3:

Select “Tweak Settings” from it. Step 4:

Navigate to PHP in Tweak settings.

Check cPanel max POST size and cPanel max upload size values.

Change the configuration according to the preference and save it.

You can also go through the same procedure via the CLI:-

Step 1:

# ssh root@IPaddress

Step 2:

Execute the following command to display the default PHP .ini file of the server.

# php –ini

Step 3:

Open it with the favourite text editor.

# vi path_to_php.ini (You may replace this with the original file path)

Step 4 :

Search for upload and post by writing M, write the preferred value.

upload_max_filesize = M

post_max_size = M

Step 5:

Restart the apache service.

# service httpd restart

# systemctl restart httpd

Read: How to Install Server Nginx on Ubuntu

#increase sql limit #Limit #MYSQL #SQL

0 notes