Bacchas at 15:37, 7 October 2025

2025-10-07T15:37:04Z

← Older revision		Revision as of 15:37, 7 October 2025
Line 45:		Line 45:
	ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';		ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
	FLUSH PRIVILEGES;		FLUSH PRIVILEGES;
			== Fix error where script to load the csv file would not execute on server===
			<p class="subhead">Edit the /etc/mysql/my.cnf file </p>
			[mysqld]
			secure-file-priv="/var/lib/mysql-files"

			''' you may have to add the line if it doesn't exist'''

	----		----
	[[#MySql Commands My Fav\|Back To Top]]-[[Main_Page\| Home]]		[[#MySql Commands My Fav\|Back To Top]]-[[Main_Page\| Home]]
	[[Category:Mysql]]		[[Category:Mysql]]

Bacchas at 14:19, 7 October 2025

2025-10-07T14:19:17Z

← Older revision		Revision as of 14:19, 7 October 2025
Line 45:		Line 45:
	ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';		ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
	FLUSH PRIVILEGES;		FLUSH PRIVILEGES;

			----
			[[#MySql Commands My Fav\|Back To Top]]-[[Main_Page\| Home]]
			[[Category:Mysql]]

Bacchas: Created page with "==Restore Database==
I used this to restore r512 from the dumped .sql file in 2025

I tried to restore it using phpmyadmin, but it did not work, got many errors. probably because it was a raw sql dump backup. The target database must already exist. if it doesn't, create it first
* log into mysql CREATE DATABASE your_database_name; mysq..."

2025-10-07T14:17:50Z

Created page with "==Restore Database== I used this to restore r512 from the dumped .sql file in 2025 I tried to restore it using phpmyadmin, but it did not work, got many errors. probably because it was a raw sql dump backup. The target database must already exist. if it doesn't, create it first * log into mysql CREATE DATABASE your_database_name; mysq..."

New page

==Restore Database==
 I used this to restore r512 from the dumped .sql file in 2025 
 I tried to restore it using phpmyadmin, but it did not work, got many errors. probably because it was a raw sql dump backup. The target database must already exist. if it doesn't, create it first

* log into mysql
CREATE DATABASE your_database_name;

mysql
use databasename;

SOURCE /path/to/file/file.sql;
<hr />

== <h4 class="yellowbackground">Script to import a CSV File into an existing Database</h4> ==
The csv file has to be in a specific directory. /var/lib/mysql-files/
The table has to already exist 
<pre>
#!/bin/bash
mysql kartest <<EOF
truncate table songs;
load data infile '/var/lib/mysql-files/songs.csv'
into table songs
fields terminated by '|'
enclosed by '"'
lines terminated by '\n'
ignore 1 rows;
EOF

</pre>

== Copy csv file to a dir and run script on server ==
<pre>
#!/bin/bash
fxcopy="/mnt/c/Users/john/Dropbox/Shining Cabinet/My Stuff/sqlitedb"
scp -i ~/.ssh/linode "$fxcopy/filename.csv" 1.1.1.1:/var/lib/mysql-files/
sleep 4
ssh -i ~/.ssh/linode root@1.1.1.1 /var/www/scripts/import.sh

</pre>

== Fixing error connecting to database from AppSheet ==
''' The permission has to be fixed to the old version in mysql server '''

ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;

MYSQL DATABASE RESTORE - Revision history

Bacchas at 15:37, 7 October 2025

Bacchas at 14:19, 7 October 2025