14.04 - How import mysql file to phpmyadmin with terminal - Ask Ubuntu


i trying import sql file phpmyadmin, am't able connect mysql in terminal using below command.

cd /opt/lampp/mysql

default command line method import exported sql file:

mysql -u {user} -p {database_to_import_into} < /dir/to/file.sql

the database needs exists before this.


Comments

Post a Comment

Popular posts from this blog

debian - Kali Linux - Debootstrap error Failed to determine codename for the release - Super User

installing new kali linux 2016 rolling release hdd via usb. i made bootable usb using universal usb. booted off usb , selected "graphical install", had issue @ beginning install prompting cannot find data in cdrom, pulled usb , waited 30 seconds, plugged in waited 30 seconds plugged in , allowed me continue through install. i enabled lvm , went through whole process once done went next step "install system" @ point error debootstrap error failed determine codename release at point cannot go further in installation. went "debian installer menu" , executed shell. shell tried mount usb /cdrom using "mount -t vfat /dev/sdb1 /cdrom" found on debian forum. receive following error "mounting /dev/sdb1 on /cdrom failed: no such file or directory" try mkdir cdrom, states exists. sdb1 usb according "mount" i not sure @ point. advice great. thanks. i had same issue installing kali linux usb. tried install os graphic...
Read more

crash - Windows Rundll32 (child process of DllHost) is crashing. How can I even identify it? - Super User

windows 10 home / "x64-based pc" / dell xps 13 9360 in reliability monitor, have many "app failures" every day. go way 2017-12-04 without variation (the details below identical), when believe machine first used. problem marked having been reported (apart problem instances in past few minutes). @magicandre1981 suggested open public problem in windows app feedback hub reason. my question is: how can identify this? causes crashes? can resolved somehow? problem details faulting application path: c:\windows\system32\rundll32.exe problem event name: appcrash fault module name: windows.ui.immersive.dll fault module version: 10.0.16299.125 exception offset: 00000000000ac885 exception code: c0000005 os version: 10.0.16299.2.0.0.768.101 bucket id: ab5106f0b0020ee0d7e0c2d4f71642fb (1720589277589816059) "anti-virus" installed (mcafee virussafe) , running no alerts, no quarantined items, no significant logs can find. sfc /scanno...
Read more

Windows XP installation, no previous version of Windows NT - Super User

i tried reinstall windows xp on lenovo s10e netbook, got error: no previous version of windows nt can found on computer. setup cannot verify qualify install upgrade product. quit setup, press f3 this notebook has no optical drive, installing xp via usb pendrive. old post. answering anyways in hope nobody ever need information since xp long since dead. xp , addional drivers: in order access harddrive need drives mass storage , drivers hdd controller. first build xp. second might be. if driver on xp installation cd not need anything. if driver not on standard cd have @ least 2 choices: create custom cd addition drives (slipstream), or load driver during setup. instructed installation process 'press f6 load additional drives'. @ stage press f6 , insert floppy relevant driver. xp , ahci in past used many storage devices. sorts of scsi, esda, ata etc etc. of these need drivers. time xp reached sp3 home systems had moved ata interface , there...
Read more