Visit Our UNIX and Linux User Community


Help importing SQL DB using phpmyadmin

 
Thread Tools Search this Thread
Special Forums Windows & DOS: Issues & Discussions Help importing SQL DB using phpmyadmin
# 1  
Old 02-03-2014
Help importing SQL DB using phpmyadmin

Hi,

When I try to import the database, getting error message.
Code:
 
No data was received to import. Either no file name was submitted or the file size
 exceeded the maximum size permitted by your PHP configuration.

I am doing this on Windows server, I updated php.ini file and stop and restated the service. I also rebooted it. But keep getting the above error message. Currently set to
Code:
upload_max_filesize = 10M

it seems I can only import a database size (Max size 2,048 KB) or below.

Please help
# 2  
Old 02-03-2014
FYI, this is a forum dedicated to unix and linux systems.

You might not get a response when asking about mysql on windows in these forums.
This User Gave Thanks to Neo For This Post:
# 3  
Old 06-21-2014
If you backed up or exported a database to a SQL file, you can import it into one of your hosting account's MySQL databases through phpMyAdmin. You can access in cPanel only, click choose file, locate the SQL file on your computer, click open, and then click Go.

Previous Thread | Next Thread
Test Your Knowledge in Computers #824
Difficulty: Medium
HTML 5 specifies scripting application programming interfaces (APIs) that can be used with JavaScript.
True or False?

8 More Discussions You Might Find Interesting

1. Solaris

How to destroy corrupt zpool without importing it?

A couple of spare disks have been added to a Solaris 10 system, and one of them has a corrupt zpool on it. I don't care about the data: I want to destroy it and re-use the disk, but it's corrupt so I can't import it. The corrupt pool is called "rpool" so I don't want to destroy it by name... (2 Replies)
Discussion started by: Mysturji
2 Replies

2. Shell Programming and Scripting

importing variables from 1 file to another

hi i want to retrieve talespace, datafile's path , size and another size in following querry in shell Create Tablespace 'A' Datafile 'Some Path' Size '10G' extent management Local uniform size '64M'; from another file say 'A.txt' where i ll dumb data in sequence separated by commas... (2 Replies)
Discussion started by: Gl@)!aTor
2 Replies

3. UNIX for Dummies Questions & Answers

importing a Physical Volume

hi guys I'm added a new disk to my server (virtual environment) It used to be a Volume Group=Vol_Group01 and Logical Volume= Log_Vol_01_Data and I see /dev/sdb Disk /dev/sdb doesn't contain a valid partition table Disk /dev/sdc: 133.1 GB, 133143986176 bytes 255 heads, 63... (3 Replies)
Discussion started by: karlochacon
3 Replies

4. Shell Programming and Scripting

Importing data from PL/SQL then sending it through mail,HELP ME!

Is anyone here know how to make a script in UNIX which will do importing data from PL/SQL then sending it through mail? Can you give me sample script with explanation so it's easy to understand,Thank you very much,any suggestion or advice is welcome, (1 Reply)
Discussion started by: Atrap
1 Replies

5. Shell Programming and Scripting

Importing Autosys Calendar.

Hi All, I'm try to import a Calendar in Autosys using below command, autocal_asc -I TKY_Test Utility to Add/Delete or Print entries in Calendar. Calendar Name: But it not allowing me to import the calendar, it asks for the calendar which is similair if we try to manually add calender... (1 Reply)
Discussion started by: arvindcgi
1 Replies

6. Programming

importing xml: problem

I'm an absolute newbie for unix... For my work, I have to import a xml file in our system (jsp+sql) via putty telnet. Once i have copied the file in the right directory, I launch this command: ./thisImport -i input/thisImport/newimport.20071130.xml -l 10 -t this is a test (as you can see),... (1 Reply)
Discussion started by: tranky
1 Replies

7. UNIX for Advanced & Expert Users

Importing PGP keys

I'm hoping someone can help get me moving in the right direction here, so bear with me. I've got 2 RedHat Linux servers, let's call them A & B. - A receives "sensitive" files, which are PGP encrypted, and immediately sends them off to B for decryption/processing/deletion - B needs to make... (1 Reply)
Discussion started by: peteroc
1 Replies

8. Shell Programming and Scripting

Importing dump file

Hi, I am trying to import 22 .dmp files but facing the problem with the last table file it never ends the import command, only the table is created but the rows of the table don't get imported. This is the problem with only ine table rest 21 tables are being imported properly. Thanks in... (2 Replies)
Discussion started by: anushilrai
2 Replies

Featured Tech Videos