|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
09-13-2021, 07:15 AM
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Oct 2018
Location: New Orleans, Louisiana. / Newcastle, England.
Posts: 1,225
|
Importing .csv in phpMyAdmin Issues
So I'm trying to import a .csv file into an SQL database using phpMyAdmin but it keeps quitting on me, I have already doubled the settings below from their default values, how much higher can I put them in order to get this .csv file imported?
There are over 400,000 rows across 7 columns. 404 Error Or, as an alternative, are there any other methods that will enable me to get this information uploaded into the database in a timely manner, short of splitting the data into 8-10 smaller .csv files? Thanks. |
|
|
|
09-13-2021, 07:21 AM
|
#2 |
|
So Fucking Banned
Industry Role:
Join Date: Nov 2008
Location: with your dream girl
Posts: 4,941
|
I would suggest to split it up into multiple files. Should only take a few minutes.
|
|
|
|
|
09-13-2021, 09:46 AM
|
#3 |
|
bored
Industry Role:
Join Date: Aug 2003
Location: PORNCMS.com
Posts: 4,790
|
anybody launch a fiverr for adult yet?
 #
__________________
# 
|
|
|
|
|
09-13-2021, 04:15 PM
|
#4 |
|
Confirmed User
Industry Role:
Join Date: Jun 2012
Location: Canada
Posts: 1,338
|
Use this PHP script: https://www.ozerov.de/bigdump/usage/
__________________
 ROBO SCRIPTS | WP CAM PLUGIN - Scripts To Promote Cam Sites - Chaturbate, BongaCams, Streamate, LiveJasmin, Stripchat... The Cam Site Builder, The Cam Multi Site Builder -> MULTIPLE CAM SITES IN ONE |
|
|
|
|
09-17-2021, 08:16 PM
|
#5 |
|
Isaac W
Industry Role:
Join Date: May 2003
Posts: 393
|
Below "file to import"
Partial import: Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. (This might be a good way to import large files, however it can break transactions.) Uncheck this, and u will be able to import as much as u want without timing out. Problem was not related to the config u did. |
|
|
|
|
09-17-2021, 09:00 PM
|
#6 |
|
Confirmed User
Industry Role:
Join Date: Apr 2021
Posts: 61
|
Not Yet..........
|
|
|
|
|
09-17-2021, 10:52 PM
|
#7 |
|
Pay It Forward
Industry Role:
Join Date: Sep 2005
Location: Yo Mama House
Posts: 77,258
|
send me a pm im buzzzed though. god u cant import that all at once.
__________________
TRUMP 2025 KEKAW!!! - The Laken Riley Act Is Law! DACA ENDED - SUPPORT AZ HCR 2060 52R - email: brassballz-at-techie.com |
|
|
|
|
09-18-2021, 03:16 AM
|
#8 |
|
Confirmed User
Industry Role:
Join Date: Apr 2019
Posts: 657
|
400,000 rows is nothing. The command line (LOAD DATA command) should handle that in under a minute.
__________________
__________________ |
|
|
|
|
09-19-2021, 05:11 AM
|
#9 |
|
Confirmed User
Join Date: Apr 2010
Posts: 272
|
Use MySql Workbench, DATA IMPORT which is found under the server tab in menu. I have used it a few times now to import large databases.
I have only used it locally so far, but you can connect to remote (server) databases with it. |
|
|
|
