Problems activating your account? Send notification email to: admin@post4vps.com
Host4Fun Budget VPS Hosting

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
mysql-server and phpmyadmin problem
#11
(03-12-2019, 12:04 PM)Hidden Refuge Wrote:  That is certainly possible.

1. Backup the database on your Windows server into the .sql format (you can also compress it if you like).

2. Transfer the .sql file to your Linux server (extract it if you compressed it).

3. Start the MySQL command line and login as root:
mysql -u root -p

4. Create a empty database where you want to import the backup into:
CREATE DATABASE databasenamehere;
(Replace "databasenamehere" with your desired database name.)

5. Exit the MySQL command line with a simple "exit" command.

6. Import the database backup into the new empty database:
mysql -u root -p databasenamehere < databasebackupfile.sql
(Again remember to adjust database name and the database backup file name.)

7. Wait until the import is complete.


That's it actually. Works on MySQL and MariaDB.

A lot of thanks dude problem has been solved ( via terminal import ).Also i just ignored that error in phpmyadmin and that is working now.  Wink
Thanks to Post4VPS and VirMach.
Reply
#12
Well, I'm glad that you finally found something that works out for you. On the other hand, ignoring a issues is not a solution to the issue Smile.
Reply
 


Possibly Related Threads...
Thread Author Replies Views Last Post
  SSH Server Vuluts 11 4,083 Yesterday, 09:12 PM
Last Post: amontes
  mysql connection with c++ program Decent12 1 156 12-19-2018, 10:26 AM
Last Post: rudra
Question How to install asapach peerflix server? Amresh 5 417 08-08-2018, 08:16 AM
Last Post: Hidden Refuge
  a small problem OldMeister 12 2,453 11-30-2017, 05:52 PM
Last Post: Decent12
  Simple Math Problem Solver Hero^ 4 1,644 02-25-2017, 05:59 PM
Last Post: Honey

Forum Jump:


Users browsing this thread: 1 Guest(s)

Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - SSDBlaze - VPSlices - Abc-Hosters - Hyper Expert - Shadow Hosting - Bladenode - HostDoc - Hostlease


About Post4VPS

Post4VPS is a forum/destiny where you can Delploy Your Free VPSs just by the Power of Posts.

We Provide VPSs of many locations like Germany,US,Canada,France,London,etc.

We also Provide VPSs of Both Linux and Windows OS.