I tried leaving out -pPassword and it did not work, I even tried -p and no password thinking maybe it needs -p but that also didn't work. That depends on your installation and operating system. only "mysql" or "/usr/bin/mysql" or similar.
If the target machine is not a Windows Xampp installation, you have to replace c:/xampp/bin/mysql by a proper command, i.e. Xampp is available as a free package that you can use to create a server hosting environment in your own computer.
#Export xampp database how to#
Watch the video explanation about XAMPP phpMyAdmin: Importing of Large SQL files to database. Menu Menu Home Script Editing Software How to use xampp for database November 6, 2022by Omos Smile Xampp is a software bundle that includes the Apache HTTP Server, MySQL database, PHP scripting language and phpMyAdmin. only "mysql" or "/usr/bin/mysql" or similar. Here you may to know how to export large database in xampp. ATTENTION: there MUST be a space between "-u" and USER, but MUST NOT be between "-p" and PASSWORD. Where USER is to replace by the admin user of MySQL ("root" in case of Xampp), PASSWORD is the password (Xampp comes without a password, you may leave out that parameter for Xampp) and DATABASENAME is the name of the database (i.e. If you want to import the database, run this command on the target machine (you have to upload and / or copy the export file to the server before):Ĭode: Select all c:/xampp/bin/mysql -u USER -pPASSWORD DATABASENAME
It may work, but it depends on releases and configuration of MySQL / MariaDB.
the data/myDB (for example) folder in XAMPP/mysql folder is the complete DB? Can I use use to insert in online hosting?
0 kommentar(er)
