answersLogoWhite

0

In navicat you can export you database as a sql file. And on your server you can import it either by command line or phpMyAdmin.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you copy a database of mysql in wamp server from one computer to another?

You have several options: * copy the database files from mysql/data/<database_name> to a new mysql Installation * use mysqldump utility to export the data from your database and load it into the new mysql installation * setup replication


How do you retrieve 10 records from table in mysql?

For work with mysql database make use of software below to open/read/scan/export-import mysql data


How do you save to the mysql database with php?

Using phpMyAdmin, connect to your database. Choose your database from the left-hand menu. At the top of the panel, select the Export tab. The Custom option should be chosen. You have the option of choosing the file format for your database. To export all tables, click Select All in the Export box. To learn more about data science please visit- Learnbay.co


How do you create a new database in MySQL?

The MySQL command is "CREATE DATABASE [dbname]" with "[dbname]" replaced with your desired database name.


How do you convert an Excel database to a Mysql database?

1. For every sheet you have in Excel, create a matching table in MySQL database 2. Export excel data to a CSV file 3. Load the CSV files into MySQL database using one of the following: 3.1 mysqlimport - Loads tables from text files in various formats 3.2 LOAD DATA INFILE command 3.3 Create the tables with CSV storage engine, replace the CSV file in the database directory


What type of database is used in Friendster?

MYSQL database


What is MyISAM in MySQL?

MyISAM is the default table engine in the MySQL database.


What database does the WAMP server refer to when it?

WAMP stands for Windows Apache Mysql PHP. Mysql is the default database in WAMP


What is wikipedia's database website?

Wikipedia uses MySQL as its database.


How do you put today's date into MySQL database?

Use: $todaysdate = date("d/m/y"); And then just send that to the MySQL database


What company is the developer of the MySQL database?

The developer of the MySQL database software was MySQL AB, which was bought by Sun 2008 for one billion dollars. Oracle then acquire sun and hence MySQL and is currently responsible for the continuing development.


What are four database programs?

Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.Oracle, MySQL, Microsoft Access and Filemaker Pro.