Member Avatar

Here is a basic question, what is the fastest way to transfer a MySQL database? Here are the variables at play: 1) Database is just shy of 3GB 2) Transfer is between two servers running different versions of MySQL 3) There will not be usage of the database during transfer, I can even shut down MySQL if needs be. 4) The database is mostly MYISAM but with a few InnoDBs and a couple Memory (VBulletin) 5) Both servers are Linux based and I have root access on both. I've done the transfer using a mysql dump, but the import took …

Member Avatar
+0 forum 15
Member Avatar

![wqe](/attachments/small/3/wqe.jpg "align-left") Select CustomerID,SalesID,CustomerName,Num_Of_Bottles,Price,Status from sales,customer where Date = DATE_FORMAT(NOW(),'%b %d, %Y') and CustomerID>0 Order by SalesID DESC

Member Avatar
+0 forum 5
Member Avatar

I am new to MySQL and navicat as well. I have been creating a database in Access and now adding records. I added about 50 records earlier and then saved them to my flashdrive to import the new data in navicat using the import wizard. The reason I have to save to FlashDrive is I dont have Access on the pc at work, and I dont have Navicat on my laptop. Complicated I know. Anyway, the first time I imported, I selected "Copy: Delete all records from destination and repopulate the source..Woked fine. Next time I tried to add more …

Member Avatar
+0 forum 11

The End.